Errors on migration script execution

Description

After a seed database import, sgl migration and xlm migration import, I am seeing random errors on migration script execution where the script attempts to apply a step and the thread appears to hang. Below is a trace from the Merge Migration Script. The last update is at 06:42:51.761. Then the program is stuck. When I exit the program, there is a connection issue and a series of errors. Is anyone else experiencing this?

-----------> MColumn.load: NO Data found for AD_Column_ID=62059 [78]
06:42:51.593 MTable.getPOclass: Use: org.compiere.model.MTable [78]
06:42:51.658 DB_PostgreSQL.convertStatement: PostgreSQL =>SELECT t.TableName, c.ColumnName,c.AD_Reference_ID,c.IsMandatory,c.IsUpdateable,c.DefaultValue,e.Name,e.Description, c.AD_Column_ID, c.IsKey,c.IsParent, c.AD_Reference_Value_ID, vr.Code, c.FieldLength, c.ValueMin, c.ValueMax, c.IsTranslated, t.AccessLevel, c.ColumnSQL, c.IsEncrypted, c.IsAllowLogging,t.IsChangeLog ,t.AD_Table_ID FROM AD_Table t INNER JOIN AD_Column c ON (t.AD_Table_ID=c.AD_Table_ID) LEFT OUTER JOIN AD_Val_Rule vr ON (c.AD_Val_Rule_ID=vr.AD_Val_Rule_ID) INNER JOIN AD_Element e ON (c.AD_Element_ID=e.AD_Element_ID) WHERE t.AD_Table_ID=? AND c.IsActive='Y'<= <SELECT t.TableName, c.ColumnName,c.AD_Reference_ID,c.IsMandatory,c.IsUpdateable,c.DefaultValue,e.Name,e.Description, c.AD_Column_ID, c.IsKey,c.IsParent, c.AD_Reference_Value_ID, vr.Code, c.FieldLength, c.ValueMin, c.ValueMax, c.IsTranslated, t.AccessLevel, c.ColumnSQL, c.IsEncrypted, c.IsAllowLogging,t.IsChangeLog ,t.AD_Table_ID FROM AD_Table t INNER JOIN AD_Column c ON (t.AD_Table_ID=c.AD_Table_ID) LEFT OUTER JOIN AD_Val_Rule vr ON (c.AD_Val_Rule_ID=vr.AD_Val_Rule_ID) INNER JOIN AD_Element e ON (c.AD_Element_ID=e.AD_Element_ID) WHERE t.AD_Table_ID=? AND c.IsActive='Y'> [78]
06:42:51.683 MColumn.saveNew: [TrxRun_7f1cbfc5-fbeb-4f5f-b3ad-ab80f07aebb6] - AD_Column - AD_Column_ID=62059 [78]
06:42:51.690 MChangeLog.saveNew: [TrxRun_7f1cbfc5-fbeb-4f5f-b3ad-ab80f07aebb6] - AD_ChangeLog - AD_ChangeLog_ID=1000014 AND AD_Column_ID=109 AND AD_Session_ID=1000001 [78]
06:42:51.692 DB_PostgreSQL.convertStatement: PostgreSQL =>INSERT INTO AD_ChangeLog (AD_ChangeLog_ID,AD_Client_ID,AD_Column_ID,AD_Org_ID,AD_Session_ID,AD_Table_ID,Created,CreatedBy,EventChangeLog,IsActive,NewValue,OldValue,Record_ID,TrxName,Updated,UpdatedBy) VALUES (1000014,0,109,0,1000001,101,TO_TIMESTAMP('2014-02-27 06:42:51','YYYY-MM-DD HH24:MI:SS'),0,'I','Y','62059','NULL',62059,'TrxRun_7f1cbfc5-fbeb-4f5f-b3ad-ab80f07aebb6',TO_TIMESTAMP('2014-02-27 06:42:51','YYYY-MM-DD HH24:MI:SS'),0)<= <INSERT INTO AD_ChangeLog (AD_ChangeLog_ID,AD_Client_ID,AD_Column_ID,AD_Org_ID,AD_Session_ID,AD_Table_ID,Created,CreatedBy,EventChangeLog,IsActive,NewValue,OldValue,Record_ID,TrxName,Updated,UpdatedBy) VALUES (1000014,0,109,0,1000001,101,TO_DATE('2014-02-27 06:42:51','YYYY-MM-DD HH24:MI:SS'),0,'I','Y','62059','NULL',62059,'TrxRun_7f1cbfc5-fbeb-4f5f-b3ad-ab80f07aebb6',TO_DATE('2014-02-27 06:42:51','YYYY-MM-DD HH24:MI:SS'),0)> [78]
06:42:51.701 DB_PostgreSQL.convertStatement: PostgreSQL =>INSERT INTO AD_Column (AD_Client_ID,AD_Column_ID,AD_Element_ID,AD_Org_ID,AD_Process_ID,AD_Reference_ID,AD_Table_ID,ColumnName,Created,CreatedBy,EntityType,FieldLength,IsActive,IsAllowLogging,IsAlwaysUpdateable,IsAutocomplete,IsEncrypted,IsIdentifier,IsKey,IsMandatory,IsParent,IsSelectionColumn,IsSyncDatabase,IsTranslated,IsUpdateable,Name,SeqNo,Updated,UpdatedBy,Version) VALUES (0,62059,524,0,53269,28,53217,'Processing',TO_TIMESTAMP('2011-08-09 14:34:42','YYYY-MM-DD HH24:MI:SS'),100,'D',1,'Y','Y','Y','N','N','N','N','N','N','N','N','N','Y','Process Now',0,TO_TIMESTAMP('2011-08-09 14:34:42','YYYY-MM-DD HH24:MI:SS'),100,0)<= <INSERT INTO AD_Column (AD_Client_ID,AD_Column_ID,AD_Element_ID,AD_Org_ID,AD_Process_ID,AD_Reference_ID,AD_Table_ID,ColumnName,Created,CreatedBy,EntityType,FieldLength,IsActive,IsAllowLogging,IsAlwaysUpdateable,IsAutocomplete,IsEncrypted,IsIdentifier,IsKey,IsMandatory,IsParent,IsSelectionColumn,IsSyncDatabase,IsTranslated,IsUpdateable,Name,SeqNo,Updated,UpdatedBy,Version) VALUES (0,62059,524,0,53269,28,53217,'Processing',TO_DATE('2011-08-09 14:34:42','YYYY-MM-DD HH24:MI:SS'),100,'D',1,'Y','Y','Y','N','N','N','N','N','N','N','N','N','Y','Process Now',0,TO_DATE('2011-08-09 14:34:42','YYYY-MM-DD HH24:MI:SS'),100,0)> [78]
06:42:51.715 MColumn.insertTranslations: #1 [78]
06:42:51.761 DB_PostgreSQL.convertStatement: PostgreSQL =>ALTER TABLE AD_Migration ADD COLUMN Processing CHAR(1) DEFAULT NULL <= <ALTER TABLE AD_Migration ADD Processing CHAR(1) DEFAULT NULL > [78]
06:43:50.675 DB_PostgreSQL.convertStatement: PostgreSQL =>SELECT COUNT(1) FROM R_Request WHERE (SalesRep_ID=? OR AD_Role_ID=?) AND Processed='N' AND (DateNextAction IS NULL OR TRUNC(DateNextAction, 'DD') <= TRUNC(CURRENT_TIMESTAMP, 'DD')) AND (R_Status_ID IS NULL OR R_Status_ID IN (SELECT R_Status_ID FROM R_Status WHERE IsClosed='N')) AND AD_Client_ID=0 AND AD_Org_ID=0 AND (R_Request_ID IS NULL OR R_Request_ID NOT IN ( SELECT Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 417 AND AD_User_ID <> 0 AND IsActive = 'Y' ))<= <SELECT COUNT(1) FROM R_Request WHERE (SalesRep_ID=? OR AD_Role_ID=?) AND Processed='N' AND (DateNextAction IS NULL OR TRUNC(DateNextAction, 'DD') <= TRUNC(SysDate, 'DD')) AND (R_Status_ID IS NULL OR R_Status_ID IN (SELECT R_Status_ID FROM R_Status WHERE IsClosed='N')) AND AD_Client_ID=0 AND AD_Org_ID=0 AND (R_Request_ID IS NULL OR R_Request_ID NOT IN ( SELECT Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 417 AND AD_User_ID <> 0 AND IsActive = 'Y' ))> [46]
06:43:50.695 MRole.get: AD_Role_ID=0, AD_User_ID=0, reload=false [46]
06:44:50.721 DB_PostgreSQL.convertStatement: PostgreSQL =>SELECT COUNT(1) FROM R_Request WHERE (SalesRep_ID=? OR AD_Role_ID=?) AND Processed='N' AND (DateNextAction IS NULL OR TRUNC(DateNextAction, 'DD') <= TRUNC(CURRENT_TIMESTAMP, 'DD')) AND (R_Status_ID IS NULL OR R_Status_ID IN (SELECT R_Status_ID FROM R_Status WHERE IsClosed='N')) AND AD_Client_ID=0 AND AD_Org_ID=0 AND (R_Request_ID IS NULL OR R_Request_ID NOT IN ( SELECT Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 417 AND AD_User_ID <> 0 AND IsActive = 'Y' ))<= <SELECT COUNT(1) FROM R_Request WHERE (SalesRep_ID=? OR AD_Role_ID=?) AND Processed='N' AND (DateNextAction IS NULL OR TRUNC(DateNextAction, 'DD') <= TRUNC(SysDate, 'DD')) AND (R_Status_ID IS NULL OR R_Status_ID IN (SELECT R_Status_ID FROM R_Status WHERE IsClosed='N')) AND AD_Client_ID=0 AND AD_Org_ID=0 AND (R_Request_ID IS NULL OR R_Request_ID NOT IN ( SELECT Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 417 AND AD_User_ID <> 0 AND IsActive = 'Y' ))> [46]
06:44:50.728 MRole.get: AD_Role_ID=0, AD_User_ID=0, reload=false [46]
06:45:50.737 DB_PostgreSQL.convertStatement: PostgreSQL =>SELECT COUNT(1) FROM R_Request WHERE (SalesRep_ID=? OR AD_Role_ID=?) AND Processed='N' AND (DateNextAction IS NULL OR TRUNC(DateNextAction, 'DD') <= TRUNC(CURRENT_TIMESTAMP, 'DD')) AND (R_Status_ID IS NULL OR R_Status_ID IN (SELECT R_Status_ID FROM R_Status WHERE IsClosed='N')) AND AD_Client_ID=0 AND AD_Org_ID=0 AND (R_Request_ID IS NULL OR R_Request_ID NOT IN ( SELECT Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 417 AND AD_User_ID <> 0 AND IsActive = 'Y' ))<= <SELECT COUNT(1) FROM R_Request WHERE (SalesRep_ID=? OR AD_Role_ID=?) AND Processed='N' AND (DateNextAction IS NULL OR TRUNC(DateNextAction, 'DD') <= TRUNC(SysDate, 'DD')) AND (R_Status_ID IS NULL OR R_Status_ID IN (SELECT R_Status_ID FROM R_Status WHERE IsClosed='N')) AND AD_Client_ID=0 AND AD_Org_ID=0 AND (R_Request_ID IS NULL OR R_Request_ID NOT IN ( SELECT Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 417 AND AD_User_ID <> 0 AND IsActive = 'Y' ))> [46]
06:45:50.745 MRole.get: AD_Role_ID=0, AD_User_ID=0, reload=false [46]
06:46:50.755 DB_PostgreSQL.convertStatement: PostgreSQL =>SELECT COUNT(1) FROM R_Request WHERE (SalesRep_ID=? OR AD_Role_ID=?) AND Processed='N' AND (DateNextAction IS NULL OR TRUNC(DateNextAction, 'DD') <= TRUNC(CURRENT_TIMESTAMP, 'DD')) AND (R_Status_ID IS NULL OR R_Status_ID IN (SELECT R_Status_ID FROM R_Status WHERE IsClosed='N')) AND AD_Client_ID=0 AND AD_Org_ID=0 AND (R_Request_ID IS NULL OR R_Request_ID NOT IN ( SELECT Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 417 AND AD_User_ID <> 0 AND IsActive = 'Y' ))<= <SELECT COUNT(1) FROM R_Request WHERE (SalesRep_ID=? OR AD_Role_ID=?) AND Processed='N' AND (DateNextAction IS NULL OR TRUNC(DateNextAction, 'DD') <= TRUNC(SysDate, 'DD')) AND (R_Status_ID IS NULL OR R_Status_ID IN (SELECT R_Status_ID FROM R_Status WHERE IsClosed='N')) AND AD_Client_ID=0 AND AD_Org_ID=0 AND (R_Request_ID IS NULL OR R_Request_ID NOT IN ( SELECT Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 417 AND AD_User_ID <> 0 AND IsActive = 'Y' ))> [46]
06:46:50.762 MRole.get: AD_Role_ID=0, AD_User_ID=0, reload=false [46]
06:47:50.771 DB_PostgreSQL.convertStatement: PostgreSQL =>SELECT COUNT(1) FROM R_Request WHERE (SalesRep_ID=? OR AD_Role_ID=?) AND Processed='N' AND (DateNextAction IS NULL OR TRUNC(DateNextAction, 'DD') <= TRUNC(CURRENT_TIMESTAMP, 'DD')) AND (R_Status_ID IS NULL OR R_Status_ID IN (SELECT R_Status_ID FROM R_Status WHERE IsClosed='N')) AND AD_Client_ID=0 AND AD_Org_ID=0 AND (R_Request_ID IS NULL OR R_Request_ID NOT IN ( SELECT Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 417 AND AD_User_ID <> 0 AND IsActive = 'Y' ))<= <SELECT COUNT(1) FROM R_Request WHERE (SalesRep_ID=? OR AD_Role_ID=?) AND Processed='N' AND (DateNextAction IS NULL OR TRUNC(DateNextAction, 'DD') <= TRUNC(SysDate, 'DD')) AND (R_Status_ID IS NULL OR R_Status_ID IN (SELECT R_Status_ID FROM R_Status WHERE IsClosed='N')) AND AD_Client_ID=0 AND AD_Org_ID=0 AND (R_Request_ID IS NULL OR R_Request_ID NOT IN ( SELECT Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 417 AND AD_User_ID <> 0 AND IsActive = 'Y' ))> [46]
06:47:50.778 MRole.get: AD_Role_ID=0, AD_User_ID=0, reload=false [46]
06:48:50.786 DB_PostgreSQL.convertStatement: PostgreSQL =>SELECT COUNT(1) FROM R_Request WHERE (SalesRep_ID=? OR AD_Role_ID=?) AND Processed='N' AND (DateNextAction IS NULL OR TRUNC(DateNextAction, 'DD') <= TRUNC(CURRENT_TIMESTAMP, 'DD')) AND (R_Status_ID IS NULL OR R_Status_ID IN (SELECT R_Status_ID FROM R_Status WHERE IsClosed='N')) AND AD_Client_ID=0 AND AD_Org_ID=0 AND (R_Request_ID IS NULL OR R_Request_ID NOT IN ( SELECT Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 417 AND AD_User_ID <> 0 AND IsActive = 'Y' ))<= <SELECT COUNT(1) FROM R_Request WHERE (SalesRep_ID=? OR AD_Role_ID=?) AND Processed='N' AND (DateNextAction IS NULL OR TRUNC(DateNextAction, 'DD') <= TRUNC(SysDate, 'DD')) AND (R_Status_ID IS NULL OR R_Status_ID IN (SELECT R_Status_ID FROM R_Status WHERE IsClosed='N')) AND AD_Client_ID=0 AND AD_Org_ID=0 AND (R_Request_ID IS NULL OR R_Request_ID NOT IN ( SELECT Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 417 AND AD_User_ID <> 0 AND IsActive = 'Y' ))> [46]
06:48:50.796 MRole.get: AD_Role_ID=0, AD_User_ID=0, reload=false [46]
06:49:50.805 DB_PostgreSQL.convertStatement: PostgreSQL =>SELECT COUNT(1) FROM R_Request WHERE (SalesRep_ID=? OR AD_Role_ID=?) AND Processed='N' AND (DateNextAction IS NULL OR TRUNC(DateNextAction, 'DD') <= TRUNC(CURRENT_TIMESTAMP, 'DD')) AND (R_Status_ID IS NULL OR R_Status_ID IN (SELECT R_Status_ID FROM R_Status WHERE IsClosed='N')) AND AD_Client_ID=0 AND AD_Org_ID=0 AND (R_Request_ID IS NULL OR R_Request_ID NOT IN ( SELECT Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 417 AND AD_User_ID <> 0 AND IsActive = 'Y' ))<= <SELECT COUNT(1) FROM R_Request WHERE (SalesRep_ID=? OR AD_Role_ID=?) AND Processed='N' AND (DateNextAction IS NULL OR TRUNC(DateNextAction, 'DD') <= TRUNC(SysDate, 'DD')) AND (R_Status_ID IS NULL OR R_Status_ID IN (SELECT R_Status_ID FROM R_Status WHERE IsClosed='N')) AND AD_Client_ID=0 AND AD_Org_ID=0 AND (R_Request_ID IS NULL OR R_Request_ID NOT IN ( SELECT Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 417 AND AD_User_ID <> 0 AND IsActive = 'Y' ))> [46]
06:49:50.813 MRole.get: AD_Role_ID=0, AD_User_ID=0, reload=false [46]
06:50:50.821 DB_PostgreSQL.convertStatement: PostgreSQL =>SELECT COUNT(1) FROM R_Request WHERE (SalesRep_ID=? OR AD_Role_ID=?) AND Processed='N' AND (DateNextAction IS NULL OR TRUNC(DateNextAction, 'DD') <= TRUNC(CURRENT_TIMESTAMP, 'DD')) AND (R_Status_ID IS NULL OR R_Status_ID IN (SELECT R_Status_ID FROM R_Status WHERE IsClosed='N')) AND AD_Client_ID=0 AND AD_Org_ID=0 AND (R_Request_ID IS NULL OR R_Request_ID NOT IN ( SELECT Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 417 AND AD_User_ID <> 0 AND IsActive = 'Y' ))<= <SELECT COUNT(1) FROM R_Request WHERE (SalesRep_ID=? OR AD_Role_ID=?) AND Processed='N' AND (DateNextAction IS NULL OR TRUNC(DateNextAction, 'DD') <= TRUNC(SysDate, 'DD')) AND (R_Status_ID IS NULL OR R_Status_ID IN (SELECT R_Status_ID FROM R_Status WHERE IsClosed='N')) AND AD_Client_ID=0 AND AD_Org_ID=0 AND (R_Request_ID IS NULL OR R_Request_ID NOT IN ( SELECT Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 417 AND AD_User_ID <> 0 AND IsActive = 'Y' ))> [46]
06:50:50.829 MRole.get: AD_Role_ID=0, AD_User_ID=0, reload=false [46]
06:51:50.837 DB_PostgreSQL.convertStatement: PostgreSQL =>SELECT COUNT(1) FROM R_Request WHERE (SalesRep_ID=? OR AD_Role_ID=?) AND Processed='N' AND (DateNextAction IS NULL OR TRUNC(DateNextAction, 'DD') <= TRUNC(CURRENT_TIMESTAMP, 'DD')) AND (R_Status_ID IS NULL OR R_Status_ID IN (SELECT R_Status_ID FROM R_Status WHERE IsClosed='N')) AND AD_Client_ID=0 AND AD_Org_ID=0 AND (R_Request_ID IS NULL OR R_Request_ID NOT IN ( SELECT Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 417 AND AD_User_ID <> 0 AND IsActive = 'Y' ))<= <SELECT COUNT(1) FROM R_Request WHERE (SalesRep_ID=? OR AD_Role_ID=?) AND Processed='N' AND (DateNextAction IS NULL OR TRUNC(DateNextAction, 'DD') <= TRUNC(SysDate, 'DD')) AND (R_Status_ID IS NULL OR R_Status_ID IN (SELECT R_Status_ID FROM R_Status WHERE IsClosed='N')) AND AD_Client_ID=0 AND AD_Org_ID=0 AND (R_Request_ID IS NULL OR R_Request_ID NOT IN ( SELECT Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 417 AND AD_User_ID <> 0 AND IsActive = 'Y' ))> [46]
06:51:50.844 MRole.get: AD_Role_ID=0, AD_User_ID=0, reload=false [46]
06:52:50.853 DB_PostgreSQL.convertStatement: PostgreSQL =>SELECT COUNT(1) FROM R_Request WHERE (SalesRep_ID=? OR AD_Role_ID=?) AND Processed='N' AND (DateNextAction IS NULL OR TRUNC(DateNextAction, 'DD') <= TRUNC(CURRENT_TIMESTAMP, 'DD')) AND (R_Status_ID IS NULL OR R_Status_ID IN (SELECT R_Status_ID FROM R_Status WHERE IsClosed='N')) AND AD_Client_ID=0 AND AD_Org_ID=0 AND (R_Request_ID IS NULL OR R_Request_ID NOT IN ( SELECT Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 417 AND AD_User_ID <> 0 AND IsActive = 'Y' ))<= <SELECT COUNT(1) FROM R_Request WHERE (SalesRep_ID=? OR AD_Role_ID=?) AND Processed='N' AND (DateNextAction IS NULL OR TRUNC(DateNextAction, 'DD') <= TRUNC(SysDate, 'DD')) AND (R_Status_ID IS NULL OR R_Status_ID IN (SELECT R_Status_ID FROM R_Status WHERE IsClosed='N')) AND AD_Client_ID=0 AND AD_Org_ID=0 AND (R_Request_ID IS NULL OR R_Request_ID NOT IN ( SELECT Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 417 AND AD_User_ID <> 0 AND IsActive = 'Y' ))> [46]
06:52:50.860 MRole.get: AD_Role_ID=0, AD_User_ID=0, reload=false [46]
06:53:50.869 DB_PostgreSQL.convertStatement: PostgreSQL =>SELECT COUNT(1) FROM R_Request WHERE (SalesRep_ID=? OR AD_Role_ID=?) AND Processed='N' AND (DateNextAction IS NULL OR TRUNC(DateNextAction, 'DD') <= TRUNC(CURRENT_TIMESTAMP, 'DD')) AND (R_Status_ID IS NULL OR R_Status_ID IN (SELECT R_Status_ID FROM R_Status WHERE IsClosed='N')) AND AD_Client_ID=0 AND AD_Org_ID=0 AND (R_Request_ID IS NULL OR R_Request_ID NOT IN ( SELECT Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 417 AND AD_User_ID <> 0 AND IsActive = 'Y' ))<= <SELECT COUNT(1) FROM R_Request WHERE (SalesRep_ID=? OR AD_Role_ID=?) AND Processed='N' AND (DateNextAction IS NULL OR TRUNC(DateNextAction, 'DD') <= TRUNC(SysDate, 'DD')) AND (R_Status_ID IS NULL OR R_Status_ID IN (SELECT R_Status_ID FROM R_Status WHERE IsClosed='N')) AND AD_Client_ID=0 AND AD_Org_ID=0 AND (R_Request_ID IS NULL OR R_Request_ID NOT IN ( SELECT Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 417 AND AD_User_ID <> 0 AND IsActive = 'Y' ))> [46]
06:53:50.876 MRole.get: AD_Role_ID=0, AD_User_ID=0, reload=false [46]
06:54:50.885 DB_PostgreSQL.convertStatement: PostgreSQL =>SELECT COUNT(1) FROM R_Request WHERE (SalesRep_ID=? OR AD_Role_ID=?) AND Processed='N' AND (DateNextAction IS NULL OR TRUNC(DateNextAction, 'DD') <= TRUNC(CURRENT_TIMESTAMP, 'DD')) AND (R_Status_ID IS NULL OR R_Status_ID IN (SELECT R_Status_ID FROM R_Status WHERE IsClosed='N')) AND AD_Client_ID=0 AND AD_Org_ID=0 AND (R_Request_ID IS NULL OR R_Request_ID NOT IN ( SELECT Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 417 AND AD_User_ID <> 0 AND IsActive = 'Y' ))<= <SELECT COUNT(1) FROM R_Request WHERE (SalesRep_ID=? OR AD_Role_ID=?) AND Processed='N' AND (DateNextAction IS NULL OR TRUNC(DateNextAction, 'DD') <= TRUNC(SysDate, 'DD')) AND (R_Status_ID IS NULL OR R_Status_ID IN (SELECT R_Status_ID FROM R_Status WHERE IsClosed='N')) AND AD_Client_ID=0 AND AD_Org_ID=0 AND (R_Request_ID IS NULL OR R_Request_ID NOT IN ( SELECT Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 417 AND AD_User_ID <> 0 AND IsActive = 'Y' ))> [46]
06:54:50.891 MRole.get: AD_Role_ID=0, AD_User_ID=0, reload=false [46]
06:55:50.900 DB_PostgreSQL.convertStatement: PostgreSQL =>SELECT COUNT(1) FROM R_Request WHERE (SalesRep_ID=? OR AD_Role_ID=?) AND Processed='N' AND (DateNextAction IS NULL OR TRUNC(DateNextAction, 'DD') <= TRUNC(CURRENT_TIMESTAMP, 'DD')) AND (R_Status_ID IS NULL OR R_Status_ID IN (SELECT R_Status_ID FROM R_Status WHERE IsClosed='N')) AND AD_Client_ID=0 AND AD_Org_ID=0 AND (R_Request_ID IS NULL OR R_Request_ID NOT IN ( SELECT Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 417 AND AD_User_ID <> 0 AND IsActive = 'Y' ))<= <SELECT COUNT(1) FROM R_Request WHERE (SalesRep_ID=? OR AD_Role_ID=?) AND Processed='N' AND (DateNextAction IS NULL OR TRUNC(DateNextAction, 'DD') <= TRUNC(SysDate, 'DD')) AND (R_Status_ID IS NULL OR R_Status_ID IN (SELECT R_Status_ID FROM R_Status WHERE IsClosed='N')) AND AD_Client_ID=0 AND AD_Org_ID=0 AND (R_Request_ID IS NULL OR R_Request_ID NOT IN ( SELECT Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 417 AND AD_User_ID <> 0 AND IsActive = 'Y' ))> [46]
06:55:50.907 MRole.get: AD_Role_ID=0, AD_User_ID=0, reload=false [46]
06:56:50.916 DB_PostgreSQL.convertStatement: PostgreSQL =>SELECT COUNT(1) FROM R_Request WHERE (SalesRep_ID=? OR AD_Role_ID=?) AND Processed='N' AND (DateNextAction IS NULL OR TRUNC(DateNextAction, 'DD') <= TRUNC(CURRENT_TIMESTAMP, 'DD')) AND (R_Status_ID IS NULL OR R_Status_ID IN (SELECT R_Status_ID FROM R_Status WHERE IsClosed='N')) AND AD_Client_ID=0 AND AD_Org_ID=0 AND (R_Request_ID IS NULL OR R_Request_ID NOT IN ( SELECT Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 417 AND AD_User_ID <> 0 AND IsActive = 'Y' ))<= <SELECT COUNT(1) FROM R_Request WHERE (SalesRep_ID=? OR AD_Role_ID=?) AND Processed='N' AND (DateNextAction IS NULL OR TRUNC(DateNextAction, 'DD') <= TRUNC(SysDate, 'DD')) AND (R_Status_ID IS NULL OR R_Status_ID IN (SELECT R_Status_ID FROM R_Status WHERE IsClosed='N')) AND AD_Client_ID=0 AND AD_Org_ID=0 AND (R_Request_ID IS NULL OR R_Request_ID NOT IN ( SELECT Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 417 AND AD_User_ID <> 0 AND IsActive = 'Y' ))> [46]
06:56:50.924 MRole.get: AD_Role_ID=0, AD_User_ID=0, reload=false [46]

Environment

Windows, Postgres, Eclipse

Status

Assignee

Michael McKay

Reporter

Michael McKay

Labels

None

Components

Fix versions

Affects versions

Priority

Major
Configure