You are viewing limited content. For full access, please sign in.

Question

Question

Oracle database manual creation

Updated August 6, 2015
asked on May 13, 2015

Hi,

My client is running laserfiche 9.1 standard on oracle database. They need to configure the audit trail but when they run the audit trail configuration wizard the tables are not able to be created by the user whose credentials are used. Now the DB admin requires that he does it manually using scripts I need confirmation if the following are the scripts that are supposed to be run:

ora-audit.sql

ora-UpdateAuditSchema1to2.sql

ora-UpdateAuditSchema2to3.sql

ora-UpdateAuditSchema3to4.sql

                   upto

ora-UpdateAuditSchema6to7.sql

If that is the case, are we to run all of them.I would also want to know why the script ora-UpdateAuditSchema1to2.sql is dropping some of the tables. Is that right?

Thanks

0 0

Replies

replied on May 13, 2015

You would just need to run the ora-audit.sql file. The ora-Update*.sql files are used to update the database from a previous version of Audit Trail.

1 0
replied on May 13, 2015

Thanks Alex

 

0 0
replied on May 18, 2015

Hi Alex,

I ran the ora-audit.sql as you said and got some errors. I have attached the log herein. Some of the errors was that the table does not exist. Whereas that tables exists in the other scripts. For example the table audit_parent exists in the ora-UpdateAuditSchema2to3.sql. (attached). Yet you said these other scripts were for updating from a previous version yet they contain tables not in the first script (ora-audit.sql).

Another error posted is "ORA-00972: identifier is too long" when trying to index one of the fields. i understand that Oracle identifiers are not allowed to exceed 30 characters in length. Will changing this identifier affect anything?

The other error is "ORA-01408: such column list already indexed". Please advise

 

oracledms.txt (71.69 KB)
Download
oraUpdateAuditSchema2to3.txt (2.34 KB)
Download
0 0
View 1 previous reply
replied on May 18, 2015

Hi Mark,

We'll need to look into this a bit more, but we'll update this thread when we have more information to report.

Regards

0 0
replied on May 20, 2015

Hi Alex, 

Much appreciated. I would also ask that you ignore the error,"ORA-00972: identifier is too long" when trying to index one of the fields. This is because we added a prefix in the create statement because the tables were being run by the admin. That's why the index became too long. We are waiting to hear from what you find out regarding the others.

0 0
replied on May 20, 2015

Hi Alex,

I went ahead and created the other unique tables in the other scripts and tried it. The error disappeared but  a new one appeared namely "Arithmetic operation resulted in an overflow." Would you tell me what this means. I pate below the event viewer logs

Laserfiche Audit Trail Configuration
   

-

EventID

0

  
     

[ Qualifiers]

0

  
     

Level

2
     

Task

0
     

Keywords

0x80000000000000
   

-

TimeCreated

  
     

[ SystemTime]

2015-05-20T09:14:51.000000000Z

  
     

EventRecordID

3548098
     

Channel

Application
     

Computer

LFProd.adma.opco.ho
     

Security

-

EventData
     

Arithmetic operation resulted in an overflow. Server stack trace: at System.Data.Odbc.OdbcStatementHandle.RowCount(SQLLEN& rowCount) at System.Data.Odbc.OdbcDataReader.GetRowCount() at System.Data.Odbc.OdbcDataReader.FirstResult() at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader, Object[] methodArguments, SQL_API odbcApiMethod) at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader) at System.Data.Odbc.OdbcCommand.ExecuteReader(CommandBehavior behavior) at AuditDBService.DataProfile.GetLoadedFiles(String repositoryName, String dateRangeId) at System.Runtime.Remoting.Messaging.StackBuilderSink._PrivateProcessMessage(IntPtr md, Object[] args, Object server, Int32 methodPtr, Boolean fExecuteInContext, Object[]& outArgs) at System.Runtime.Remoting.Messaging.StackBuilderSink.SyncProcessMessage(IMessage msg, Int32 methodPtr, Boolean fExecuteInContext) Exception rethrown at [0]: at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg) at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type) at AuditRemoting.IImportStatus.GetLoadedFiles(String reposName, String dateRangeId) at WebAuditConfig.ItemsInDateRange.GetItemsInDateRange(String dateRangeId, String Repository)

 

 

 

Laserfiche Audit Trail Reporting
   

-

EventID

0

  
     

[ Qualifiers]

0

  
     

Level

2
     

Task

0
     

Keywords

0x80000000000000
   

-

TimeCreated

  
     

[ SystemTime]

2015-05-20T09:15:06.000000000Z

  
     

EventRecordID

3548099
     

Channel

Application
     

Computer

LFProd.adma.opco.ho
     

Security

-

EventData
     

Arithmetic operation resulted in an overflow. Server stack trace: at System.Data.Odbc.OdbcStatementHandle.RowCount(SQLLEN& rowCount) at System.Data.Odbc.OdbcDataReader.GetRowCount() at System.Data.Odbc.OdbcDataReader.FirstResult() at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader, Object[] methodArguments, SQL_API odbcApiMethod) at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader) at System.Data.Odbc.OdbcCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Odbc.OdbcCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) at AuditDBService.RemotableReporting.GetTableColumns(String repo, String tableName) at System.Runtime.Remoting.Messaging.StackBuilderSink._PrivateProcessMessage(IntPtr md, Object[] args, Object server, Int32 methodPtr, Boolean fExecuteInContext, Object[]& outArgs) at System.Runtime.Remoting.Messaging.StackBuilderSink.SyncProcessMessage(IMessage msg, Int32 methodPtr, Boolean fExecuteInContext) Exception rethrown at [0]: at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg) at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type) at AuditRemoting.IReporting.GetTableColumns(String repo, String tableName) at WebAuditReport.DataFieldManager.RetrieveFieldsFromDBTable(String table, String repo) at WebAuditReport.DataFieldManager.RetrieveFieldsFromDBTables(List`1 tables, String repo) at WebAuditReport.DataFieldManager.ReadAllDataFields(String listfile, String repo) at WebAuditReport.DataFieldManager.Init(String repo) at WebAuditReport.DataFieldManager..ctor(String repo) at WebAuditReport.classes.DBDataDescriptor..ctor(String repository) at WebAuditReport.classes.DBDataDescriptor.GetDescriptor(String repository) at WebAuditReport.OverallReportParams.OnReposChange(String newRepos) at WebAuditReport._Default.ReportMan_Load_Click(Object sender, EventArgs e) at System.Web.UI.WebControls.Button.OnClick(EventArgs e) at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

 

0 0
replied on August 6, 2015

This is fixed in the latest service pack for Audit Trail 9.2. Please see KB 1013659

Audit Trail Reporting could fail to create reporting databases on Oracle. This issue is now resolved. (127958)

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Attachments
Related Posts
Loading ...