Skip to main content

Error in transaction table

David Paras
  • Updated

Error:

What does this mean? It seems to make my process flow fail.

Diagnostic Message:

Error while making entry in table au_transactiondata Start Time:2012-08-23 11:13:06 End Time:2012-08-23 11:13:06 Run Time:93 ms[Invalid column name 'AU_activityStatus'.]

 

Cause: The log database is configured as case sensitive on the Server or Database Level.

 

Solution:

Case Sensitive and case insensitive is set as part of ‘COLLATION’.

For example:- if collation is “SQL_Latin1_General_CP1_CI_AS” then CI = Case Insensitive and CS = Case Sensitive.

COLLATION can be set at SERVER/DATABASE/COLUMN level.

You can check collation by:-

To check Server collation:- SELECT SERVERPROPERTY('COLLATION');
To check Database Collation : SELECT DATABASEPROPERTYEX('<dbname>', 'Collation') SQLCollation;

Comments

1 comment

Date Votes
  • David Paras

    We have also resolved the following error by reconfiguring the case sensitivity:

    We get this error when opening the Process Flow Designer:

    Persistence error: Nested error: java.sql.SQLException: Column not found: AU_MAILSOURCE.AU_BODYCONTENTTYPE in statement [SELECT AU_MAILSOURCE.au_id,AU_MAILSOURCE.au_version .... AU_MAILSOURCE.au_creationDate DESC]

     

    We changed the SQL collation from CS_AS to CI_AS.

    0

Article is closed for comments.