0 Replies Latest reply on Sep 25, 2019 1:39 AM by bpierce

    Transaction Logging to SQL Database in 12.6.2 not working

    bpierce

      Has anyone else been able to successfully log transactions to a SQL transactional logging database in 12.6.2?  We recently upgraded and cannot get the transactions to log.  Our  docserv.xml looks like this:

       

      <section name="TransactionLogDatabase">

             <entry name="enabled">Yes</entry>

                  <entry name="class">sun.jdbc.odbc.JdbcOdbcDriver</entry>

                  <entry name="URL">jdbc:odbc:SANDDEV_DIAMOND_LOG</entry>

              <entry name="userid">sa</entry>

                  <entry name="password"></entry>

                  <entry name="time.type">weekly</entry>

                  <entry name="time.count">2</entry>

                  <entry name="time.startofweek">monday</entry>

                  <entry name="close.database">N</entry>

                  <section name="columns">

                      <entry name="Reqtype">REQTYPE</entry>

                      <entry name="REPLYTOQUEUE">REPLYTOQUEUE</entry>

                      <entry name="REPLYTOQUEUEMANAGER">REPLYTOQUEUEMANAGER</entry>

                      <entry name="IDSHOSTNAME">IDSHOSTNAME</entry>

                      <entry name="CONFIG">CONFIG</entry>

                      <entry name="Results">RESULTS</entry>

                      <entry name="RPResults">RPRESULTS</entry>

                      <entry name="DOCBASEGUID">DOCBASEGUID</entry>

                      <entry name="EXTRFILE">EXTRFILE</entry>

                      <entry name="ServerTimeSpent">SERVERTIMESPENT</entry>

                 <entry name="SentToWip">SentToWip</entry>

                  </section>

              </section>

       

      Our ODBC connection tests successfully from the server and our account has the correct permissions to the database.  Any help or suggestions are appreciated.  We do not have any issues in lower versions of Documaker.

       

      Thanks!~