Is the INSTANCE_ID supposed to be set in TRIRIGAWEB.properties?


I am getting an error in the server.log which reads as follows:

2016-05-09 09:26:44,840 ERROR [com.tririga.architecture.security.dataaccess.AuthenticationDAO](WebContainer : 4) EXCEPTION
com.tririga.platform.persistence.PersistenceException: Error executing sql: Sql[SEE BELOW]; ORA-01438: value larger than specified precision allowed for this column
; nested exception is java.sql.SQLDataException: ORA-01438: value larger than specified precision allowed for this column


INSERT INTO WF_EVENT (INSTANCE_ID, BO_TYPE_ID, BO_ID, BO_VERSION, EVENT_ID, NEXT_BO_TYPE_ID, NEXT_BO_ID, NEXT_BO_VERSION, USER_ID, DEPARTMENT_ID, COMPANY_ID, PROJECT_ID, CREATED_BY, CREATED_DATE, MODULE_ID, NEXT_MODULE_ID, ASSOC_STRING, FROM_INTEGRATION, IR_ID, IE_ID, IE_NAME) VALUES (27972745598,106872,24687108,290,'WF USER LOGIN',0,0,0,24687108,0,208133,1,0,getDate(),7,0,'',0,24687108,27972745598,'WF USER LOGIN')

Should I set the INSTANCE_ID parameter in TRIRIGAWEB.properties? We are running a single instance server. Thanks in advance.

Continue reading

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s