Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

Collections Management – “Cannot insert duplicate key row in object 'dbo.ASITAB20' with unique index 'AK2ASITAB20'” error message in support debugging log when opening SmartList.

Posted on by Microsoft Employee

We are using GP2013 R2 and Professional Advantage’s Collection module (version 12.00g46). While running GP’s support debugging tool, we noticed these error messages (see below) occur when we open SmartList. (When I uninstall collections from my workstation, the error messages do not occur, so I feel they can be attributed to the collections module or at least partially attributed to them.) Has anyone encountered these messages before and have an explanation/resolution?

Error messages from support debugging log:

/* Date: 07/15/2015 Time: 10:28:43

stmt(16578408):*/

BEGIN DECLARE @num int EXEC DYNAMICS.dbo.zDP_ASITAB20SI 0, 8, 345, 200, 1157, 'Customer Number', 'Collections Customer Number', '', 0, 1, 5, '', 0, 0, 0, '', '', 'CN_Invoice_Notes_OPEN', @num OUT SELECT @num END

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(23000) Native Err:(2601) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert duplicate key row in object 'dbo.ASITAB20' with unique index 'AK2ASITAB20'. The duplicate key value is (0, 8, 1157, 200).*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(01000) Native Err:(3621) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) stmt(16578408):*/

*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) status(54):*/

SWSTATUS DUMP*/

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16618184):*/

{CALL DYNAMICS.dbo.zDP_ASITAB20L_1(0,8,-32768,0,8,32767)}

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16578408):*/

BEGIN DECLARE @num int EXEC DYNAMICS.dbo.zDP_ASITAB20SI 0, 8, 345, 201, 1157, 'Corporate Customer Number', 'Collections Corporate Customer Number', '', 0, 1, 5, '', 0, 0, 0, '', '', 'CN_Invoice_Notes_OPEN', @num OUT SELECT @num END

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(23000) Native Err:(2601) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert duplicate key row in object 'dbo.ASITAB20' with unique index 'AK2ASITAB20'. The duplicate key value is (0, 8, 1157, 201).*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(01000) Native Err:(3621) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) stmt(16578408):*/

*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) status(54):*/

SWSTATUS DUMP*/

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16618184):*/

{CALL DYNAMICS.dbo.zDP_ASITAB20L_1(0,8,-32768,0,8,32767)}

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16578408):*/

BEGIN DECLARE @num int EXEC DYNAMICS.dbo.zDP_ASITAB20SI 0, 8, 345, 202, 1157, 'RM Document Type-All', 'Collections RM Document Type-All', '', 0, 1, 2, '', 0, 0, 0, '', '', 'CN_Invoice_Notes_OPEN', @num OUT SELECT @num END

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(23000) Native Err:(2601) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert duplicate key row in object 'dbo.ASITAB20' with unique index 'AK2ASITAB20'. The duplicate key value is (0, 8, 1157, 202).*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(01000) Native Err:(3621) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) stmt(16578408):*/

*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) status(54):*/

SWSTATUS DUMP*/

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16618184):*/

{CALL DYNAMICS.dbo.zDP_ASITAB20L_1(0,8,-32768,0,8,32767)}

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16578408):*/

BEGIN DECLARE @num int EXEC DYNAMICS.dbo.zDP_ASITAB20SI 0, 8, 345, 203, 1157, 'Document Number', 'Collections Document Number', '', 0, 1, 5, '', 0, 0, 0, '', '', 'CN_Invoice_Notes_OPEN', @num OUT SELECT @num END

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(23000) Native Err:(2601) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert duplicate key row in object 'dbo.ASITAB20' with unique index 'AK2ASITAB20'. The duplicate key value is (0, 8, 1157, 203).*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(01000) Native Err:(3621) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) stmt(16578408):*/

*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) status(54):*/

SWSTATUS DUMP*/

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16618184):*/

{CALL DYNAMICS.dbo.zDP_ASITAB20L_1(0,8,-32768,0,8,32767)}

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16578408):*/

BEGIN DECLARE @num int EXEC DYNAMICS.dbo.zDP_ASITAB20SI 0, 8, 345, 204, 1157, 'Note Index', 'Collections Note Index', '', 0, 1, 2, '', 0, 0, 0, '', '', 'CN_Invoice_Notes_OPEN', @num OUT SELECT @num END

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(23000) Native Err:(2601) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert duplicate key row in object 'dbo.ASITAB20' with unique index 'AK2ASITAB20'. The duplicate key value is (0, 8, 1157, 204).*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(01000) Native Err:(3621) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) stmt(16578408):*/

*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) status(54):*/

SWSTATUS DUMP*/

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16618184):*/

{CALL DYNAMICS.dbo.zDP_ASITAB20L_1(0,8,-32768,0,8,32767)}

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16578408):*/

BEGIN DECLARE @num int EXEC DYNAMICS.dbo.zDP_ASITAB20SI 0, 8, 345, 205, 1157, 'Action Type', 'Collections Action Type', '', 0, 1, 7, '', 0, 0, 0, '', '', 'CN_Invoice_Notes_OPEN', @num OUT SELECT @num END

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(23000) Native Err:(2601) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert duplicate key row in object 'dbo.ASITAB20' with unique index 'AK2ASITAB20'. The duplicate key value is (0, 8, 1157, 205).*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(01000) Native Err:(3621) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) stmt(16578408):*/

*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) status(54):*/

SWSTATUS DUMP*/

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16618184):*/

{CALL DYNAMICS.dbo.zDP_ASITAB20L_1(0,8,-32768,0,8,32767)}

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16578408):*/

BEGIN DECLARE @num int EXEC DYNAMICS.dbo.zDP_ASITAB20SI 0, 8, 345, 206, 1157, 'Action Amount', 'Collections Action Amount', '', 0, 1, 4, '', 0, 0, 0, '', '', 'CN_Invoice_Notes_OPEN', @num OUT SELECT @num END

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(23000) Native Err:(2601) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert duplicate key row in object 'dbo.ASITAB20' with unique index 'AK2ASITAB20'. The duplicate key value is (0, 8, 1157, 206).*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(01000) Native Err:(3621) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) stmt(16578408):*/

*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) status(54):*/

SWSTATUS DUMP*/

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16618184):*/

{CALL DYNAMICS.dbo.zDP_ASITAB20L_1(0,8,-32768,0,8,32767)}

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16578408):*/

BEGIN DECLARE @num int EXEC DYNAMICS.dbo.zDP_ASITAB20SI 0, 8, 345, 207, 1157, 'Current Trx Amount', 'Collections Current Trx Amount', '', 0, 1, 4, '', 0, 0, 0, '', '', 'CN_Invoice_Notes_OPEN', @num OUT SELECT @num END

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(23000) Native Err:(2601) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert duplicate key row in object 'dbo.ASITAB20' with unique index 'AK2ASITAB20'. The duplicate key value is (0, 8, 1157, 207).*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(01000) Native Err:(3621) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) stmt(16578408):*/

*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) status(54):*/

SWSTATUS DUMP*/

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16618184):*/

{CALL DYNAMICS.dbo.zDP_ASITAB20L_1(0,8,-32768,0,8,32767)}

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16578408):*/

BEGIN DECLARE @num int EXEC DYNAMICS.dbo.zDP_ASITAB20SI 0, 8, 345, 208, 1157, 'Currency ID', 'Collections Currency ID', '', 0, 1, 5, '', 0, 0, 0, '', '', 'CN_Invoice_Notes_OPEN', @num OUT SELECT @num END

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(23000) Native Err:(2601) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert duplicate key row in object 'dbo.ASITAB20' with unique index 'AK2ASITAB20'. The duplicate key value is (0, 8, 1157, 208).*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(01000) Native Err:(3621) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) stmt(16578408):*/

*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) status(54):*/

SWSTATUS DUMP*/

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16618184):*/

{CALL DYNAMICS.dbo.zDP_ASITAB20L_1(0,8,-32768,0,8,32767)}

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16578408):*/

BEGIN DECLARE @num int EXEC DYNAMICS.dbo.zDP_ASITAB20SI 0, 8, 345, 209, 1157, 'Currency Index', 'Collections Currency Index', '', 0, 1, 2, '', 0, 0, 0, '', '', 'CN_Invoice_Notes_OPEN', @num OUT SELECT @num END

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(23000) Native Err:(2601) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert duplicate key row in object 'dbo.ASITAB20' with unique index 'AK2ASITAB20'. The duplicate key value is (0, 8, 1157, 209).*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(01000) Native Err:(3621) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) stmt(16578408):*/

*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) status(54):*/

SWSTATUS DUMP*/

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16618184):*/

{CALL DYNAMICS.dbo.zDP_ASITAB20L_1(0,8,-32768,0,8,32767)}

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16578408):*/

BEGIN DECLARE @num int EXEC DYNAMICS.dbo.zDP_ASITAB20SI 0, 8, 345, 210, 1157, 'Aging Bucket', 'Collections Aging Bucket', '', 0, 1, 2, '', 0, 0, 0, '', '', 'CN_Invoice_Notes_OPEN', @num OUT SELECT @num END

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(23000) Native Err:(2601) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert duplicate key row in object 'dbo.ASITAB20' with unique index 'AK2ASITAB20'. The duplicate key value is (0, 8, 1157, 210).*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(01000) Native Err:(3621) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) stmt(16578408):*/

*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) status(54):*/

SWSTATUS DUMP*/

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16618184):*/

{CALL DYNAMICS.dbo.zDP_ASITAB20L_1(0,8,-32768,0,8,32767)}

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16578408):*/

BEGIN DECLARE @num int EXEC DYNAMICS.dbo.zDP_ASITAB20SI 0, 8, 345, 101, 1157, 'Customer Number', 'Collections Customer Number', '', 0, 1, 5, '', 0, 0, 0, '', '', 'CN_Notes', @num OUT SELECT @num END

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(23000) Native Err:(2601) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert duplicate key row in object 'dbo.ASITAB20' with unique index 'AK2ASITAB20'. The duplicate key value is (0, 8, 1157, 101).*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(01000) Native Err:(3621) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) stmt(16578408):*/

*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) status(54):*/

SWSTATUS DUMP*/

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16618184):*/

{CALL DYNAMICS.dbo.zDP_ASITAB20L_1(0,8,-32768,0,8,32767)}

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16578408):*/

BEGIN DECLARE @num int EXEC DYNAMICS.dbo.zDP_ASITAB20SI 0, 8, 345, 102, 1157, 'Corporate Customer Number', 'Collections Corporate Customer Number', '', 0, 1, 5, '', 0, 0, 0, '', '', 'CN_Notes', @num OUT SELECT @num END

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(23000) Native Err:(2601) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert duplicate key row in object 'dbo.ASITAB20' with unique index 'AK2ASITAB20'. The duplicate key value is (0, 8, 1157, 102).*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(01000) Native Err:(3621) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) stmt(16578408):*/

*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) status(54):*/

SWSTATUS DUMP*/

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16618184):*/

{CALL DYNAMICS.dbo.zDP_ASITAB20L_1(0,8,-32768,0,8,32767)}

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16578408):*/

BEGIN DECLARE @num int EXEC DYNAMICS.dbo.zDP_ASITAB20SI 0, 8, 345, 103, 1157, 'Date', 'Collections Date', '', 0, 1, 3, '', 0, 0, 0, '', '', 'CN_Notes', @num OUT SELECT @num END

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(23000) Native Err:(2601) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert duplicate key row in object 'dbo.ASITAB20' with unique index 'AK2ASITAB20'. The duplicate key value is (0, 8, 1157, 103).*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(01000) Native Err:(3621) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) stmt(16578408):*/

*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) status(54):*/

SWSTATUS DUMP*/

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16618184):*/

{CALL DYNAMICS.dbo.zDP_ASITAB20L_1(0,8,-32768,0,8,32767)}

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16578408):*/

BEGIN DECLARE @num int EXEC DYNAMICS.dbo.zDP_ASITAB20SI 0, 8, 345, 104, 1157, 'Contact Date', 'Collections Contact Date', '', 0, 1, 3, '', 0, 0, 0, '', '', 'CN_Notes', @num OUT SELECT @num END

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(23000) Native Err:(2601) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert duplicate key row in object 'dbo.ASITAB20' with unique index 'AK2ASITAB20'. The duplicate key value is (0, 8, 1157, 104).*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(01000) Native Err:(3621) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) stmt(16578408):*/

*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) status(54):*/

SWSTATUS DUMP*/

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16618184):*/

{CALL DYNAMICS.dbo.zDP_ASITAB20L_1(0,8,-32768,0,8,32767)}

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16578408):*/

BEGIN DECLARE @num int EXEC DYNAMICS.dbo.zDP_ASITAB20SI 0, 8, 345, 105, 1157, 'Time', 'Collections Time', '', 0, 1, 12, '', 0, 0, 0, '', '', 'CN_Notes', @num OUT SELECT @num END

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(23000) Native Err:(2601) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert duplicate key row in object 'dbo.ASITAB20' with unique index 'AK2ASITAB20'. The duplicate key value is (0, 8, 1157, 105).*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(01000) Native Err:(3621) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) stmt(16578408):*/

*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) status(54):*/

SWSTATUS DUMP*/

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16618184):*/

{CALL DYNAMICS.dbo.zDP_ASITAB20L_1(0,8,-32768,0,8,32767)}

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16578408):*/

BEGIN DECLARE @num int EXEC DYNAMICS.dbo.zDP_ASITAB20SI 0, 8, 345, 106, 1157, 'Contact Time', 'Collections Contact Time', '', 0, 1, 12, '', 0, 0, 0, '', '', 'CN_Notes', @num OUT SELECT @num END

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(23000) Native Err:(2601) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert duplicate key row in object 'dbo.ASITAB20' with unique index 'AK2ASITAB20'. The duplicate key value is (0, 8, 1157, 106).*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(01000) Native Err:(3621) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) stmt(16578408):*/

*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) status(54):*/

SWSTATUS DUMP*/

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16618184):*/

{CALL DYNAMICS.dbo.zDP_ASITAB20L_1(0,8,-32768,0,8,32767)}

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16578408):*/

BEGIN DECLARE @num int EXEC DYNAMICS.dbo.zDP_ASITAB20SI 0, 8, 345, 107, 1157, 'Note Index', 'Collections Note Index', '', 0, 1, 2, '', 0, 0, 0, '', '', 'CN_Notes', @num OUT SELECT @num END

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(23000) Native Err:(2601) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert duplicate key row in object 'dbo.ASITAB20' with unique index 'AK2ASITAB20'. The duplicate key value is (0, 8, 1157, 107).*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(01000) Native Err:(3621) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) stmt(16578408):*/

*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) status(54):*/

SWSTATUS DUMP*/

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16618184):*/

{CALL DYNAMICS.dbo.zDP_ASITAB20L_1(0,8,-32768,0,8,32767)}

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16578408):*/

BEGIN DECLARE @num int EXEC DYNAMICS.dbo.zDP_ASITAB20SI 0, 8, 345, 108, 1157, 'CN Revision Number', 'Collections CN Revision Number', '', 0, 1, 2, '', 0, 0, 0, '', '', 'CN_Notes', @num OUT SELECT @num END

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(23000) Native Err:(2601) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert duplicate key row in object 'dbo.ASITAB20' with unique index 'AK2ASITAB20'. The duplicate key value is (0, 8, 1157, 108).*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(01000) Native Err:(3621) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) stmt(16578408):*/

*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) status(54):*/

SWSTATUS DUMP*/

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16618184):*/

{CALL DYNAMICS.dbo.zDP_ASITAB20L_1(0,8,-32768,0,8,32767)}

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16578408):*/

BEGIN DECLARE @num int EXEC DYNAMICS.dbo.zDP_ASITAB20SI 0, 8, 345, 109, 1157, 'CN Group Note', 'Collections CN Group Note', '', 0, 1, 6, '', 0, 0, 0, '', '', 'CN_Notes', @num OUT SELECT @num END

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(23000) Native Err:(2601) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert duplicate key row in object 'dbo.ASITAB20' with unique index 'AK2ASITAB20'. The duplicate key value is (0, 8, 1157, 109).*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(01000) Native Err:(3621) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) stmt(16578408):*/

*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) status(54):*/

SWSTATUS DUMP*/

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16618184):*/

{CALL DYNAMICS.dbo.zDP_ASITAB20L_1(0,8,-32768,0,8,32767)}

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16578408):*/

BEGIN DECLARE @num int EXEC DYNAMICS.dbo.zDP_ASITAB20SI 0, 8, 345, 110, 1157, 'Caller ID String', 'Collections Caller ID String', '', 0, 1, 5, '', 0, 0, 0, '', '', 'CN_Notes', @num OUT SELECT @num END

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(23000) Native Err:(2601) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert duplicate key row in object 'dbo.ASITAB20' with unique index 'AK2ASITAB20'. The duplicate key value is (0, 8, 1157, 110).*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(01000) Native Err:(3621) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) stmt(16578408):*/

*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) status(54):*/

SWSTATUS DUMP*/

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16618184):*/

{CALL DYNAMICS.dbo.zDP_ASITAB20L_1(0,8,-32768,0,8,32767)}

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16578408):*/

BEGIN DECLARE @num int EXEC DYNAMICS.dbo.zDP_ASITAB20SI 0, 8, 345, 111, 1157, 'Action Promised', 'Collections Action Promised', '', 0, 1, 5, '', 0, 0, 0, '', '', 'CN_Notes', @num OUT SELECT @num END

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(23000) Native Err:(2601) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert duplicate key row in object 'dbo.ASITAB20' with unique index 'AK2ASITAB20'. The duplicate key value is (0, 8, 1157, 111).*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(01000) Native Err:(3621) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) stmt(16578408):*/

*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) status(54):*/

SWSTATUS DUMP*/

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16618184):*/

{CALL DYNAMICS.dbo.zDP_ASITAB20L_1(0,8,-32768,0,8,32767)}

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16578408):*/

BEGIN DECLARE @num int EXEC DYNAMICS.dbo.zDP_ASITAB20SI 0, 8, 345, 112, 1157, 'Action Type', 'Collections Action Type', '', 0, 1, 7, '', 0, 0, 0, '', '', 'CN_Notes', @num OUT SELECT @num END

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(23000) Native Err:(2601) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert duplicate key row in object 'dbo.ASITAB20' with unique index 'AK2ASITAB20'. The duplicate key value is (0, 8, 1157, 112).*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(01000) Native Err:(3621) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) stmt(16578408):*/

*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) status(54):*/

SWSTATUS DUMP*/

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16618184):*/

{CALL DYNAMICS.dbo.zDP_ASITAB20L_1(0,8,-32768,0,8,32767)}

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16578408):*/

BEGIN DECLARE @num int EXEC DYNAMICS.dbo.zDP_ASITAB20SI 0, 8, 345, 113, 1157, 'Action Date', 'Collections Action Date', '', 0, 1, 3, '', 0, 0, 0, '', '', 'CN_Notes', @num OUT SELECT @num END

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(23000) Native Err:(2601) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert duplicate key row in object 'dbo.ASITAB20' with unique index 'AK2ASITAB20'. The duplicate key value is (0, 8, 1157, 113).*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(01000) Native Err:(3621) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) stmt(16578408):*/

*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) status(54):*/

SWSTATUS DUMP*/

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16618184):*/

{CALL DYNAMICS.dbo.zDP_ASITAB20L_1(0,8,-32768,0,8,32767)}

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16578408):*/

BEGIN DECLARE @num int EXEC DYNAMICS.dbo.zDP_ASITAB20SI 0, 8, 345, 114, 1157, 'Action Assigned To', 'Collections Action Assigned To', '', 0, 1, 5, '', 0, 0, 0, '', '', 'CN_Notes', @num OUT SELECT @num END

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(23000) Native Err:(2601) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert duplicate key row in object 'dbo.ASITAB20' with unique index 'AK2ASITAB20'. The duplicate key value is (0, 8, 1157, 114).*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(01000) Native Err:(3621) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) stmt(16578408):*/

*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) status(54):*/

SWSTATUS DUMP*/

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16618184):*/

{CALL DYNAMICS.dbo.zDP_ASITAB20L_1(0,8,-32768,0,8,32767)}

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16578408):*/

BEGIN DECLARE @num int EXEC DYNAMICS.dbo.zDP_ASITAB20SI 0, 8, 345, 115, 1157, 'Action Completed', 'Collections Action Completed', '', 0, 1, 6, '', 0, 0, 0, '', '', 'CN_Notes', @num OUT SELECT @num END

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(23000) Native Err:(2601) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert duplicate key row in object 'dbo.ASITAB20' with unique index 'AK2ASITAB20'. The duplicate key value is (0, 8, 1157, 115).*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(01000) Native Err:(3621) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) stmt(16578408):*/

*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) status(54):*/

SWSTATUS DUMP*/

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16618184):*/

{CALL DYNAMICS.dbo.zDP_ASITAB20L_1(0,8,-32768,0,8,32767)}

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16578408):*/

BEGIN DECLARE @num int EXEC DYNAMICS.dbo.zDP_ASITAB20SI 0, 8, 345, 116, 1157, 'Action Completed Sort By', 'Collections Action Completed Sort By', '', 0, 1, 6, '', 0, 0, 0, '', '', 'CN_Notes', @num OUT SELECT @num END

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(23000) Native Err:(2601) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert duplicate key row in object 'dbo.ASITAB20' with unique index 'AK2ASITAB20'. The duplicate key value is (0, 8, 1157, 116).*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(01000) Native Err:(3621) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) stmt(16578408):*/

*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) status(54):*/

SWSTATUS DUMP*/

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16618184):*/

{CALL DYNAMICS.dbo.zDP_ASITAB20L_1(0,8,-32768,0,8,32767)}

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16578408):*/

BEGIN DECLARE @num int EXEC DYNAMICS.dbo.zDP_ASITAB20SI 0, 8, 345, 117, 1157, 'Action Completed Date', 'Collections Action Completed Date', '', 0, 1, 3, '', 0, 0, 0, '', '', 'CN_Notes', @num OUT SELECT @num END

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(23000) Native Err:(2601) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert duplicate key row in object 'dbo.ASITAB20' with unique index 'AK2ASITAB20'. The duplicate key value is (0, 8, 1157, 117).*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(01000) Native Err:(3621) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) stmt(16578408):*/

*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) status(54):*/

SWSTATUS DUMP*/

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16618184):*/

{CALL DYNAMICS.dbo.zDP_ASITAB20L_1(0,8,-32768,0,8,32767)}

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16578408):*/

BEGIN DECLARE @num int EXEC DYNAMICS.dbo.zDP_ASITAB20SI 0, 8, 345, 118, 1157, 'Action Completed Time', 'Collections Action Completed Time', '', 0, 1, 12, '', 0, 0, 0, '', '', 'CN_Notes', @num OUT SELECT @num END

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(23000) Native Err:(2601) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert duplicate key row in object 'dbo.ASITAB20' with unique index 'AK2ASITAB20'. The duplicate key value is (0, 8, 1157, 118).*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(01000) Native Err:(3621) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) stmt(16578408):*/

*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) status(54):*/

SWSTATUS DUMP*/

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16618184):*/

{CALL DYNAMICS.dbo.zDP_ASITAB20L_1(0,8,-32768,0,8,32767)}

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16578408):*/

BEGIN DECLARE @num int EXEC DYNAMICS.dbo.zDP_ASITAB20SI 0, 8, 345, 119, 1157, 'Amount Promised', 'Collections Amount Promised', '', 0, 1, 4, '', 0, 0, 0, '', '', 'CN_Notes', @num OUT SELECT @num END

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(23000) Native Err:(2601) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert duplicate key row in object 'dbo.ASITAB20' with unique index 'AK2ASITAB20'. The duplicate key value is (0, 8, 1157, 119).*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(01000) Native Err:(3621) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) stmt(16578408):*/

*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) status(54):*/

SWSTATUS DUMP*/

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16618184):*/

{CALL DYNAMICS.dbo.zDP_ASITAB20L_1(0,8,-32768,0,8,32767)}

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16578408):*/

BEGIN DECLARE @num int EXEC DYNAMICS.dbo.zDP_ASITAB20SI 0, 8, 345, 120, 1157, 'Amount Received', 'Collections Amount Received', '', 0, 1, 4, '', 0, 0, 0, '', '', 'CN_Notes', @num OUT SELECT @num END

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(23000) Native Err:(2601) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert duplicate key row in object 'dbo.ASITAB20' with unique index 'AK2ASITAB20'. The duplicate key value is (0, 8, 1157, 120).*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(01000) Native Err:(3621) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) stmt(16578408):*/

*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) status(54):*/

SWSTATUS DUMP*/

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16618184):*/

{CALL DYNAMICS.dbo.zDP_ASITAB20L_1(0,8,-32768,0,8,32767)}

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16578408):*/

BEGIN DECLARE @num int EXEC DYNAMICS.dbo.zDP_ASITAB20SI 0, 8, 345, 121, 1157, 'User ID', 'Collector', '', 0, 1, 5, '', 0, 0, 0, '', '', 'CN_Notes', @num OUT SELECT @num END

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(23000) Native Err:(2601) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert duplicate key row in object 'dbo.ASITAB20' with unique index 'AK2ASITAB20'. The duplicate key value is (0, 8, 1157, 121).*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(01000) Native Err:(3621) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) stmt(16578408):*/

*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) status(54):*/

SWSTATUS DUMP*/

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16618184):*/

{CALL DYNAMICS.dbo.zDP_ASITAB20L_1(0,8,-32768,0,8,32767)}

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16578408):*/

BEGIN DECLARE @num int EXEC DYNAMICS.dbo.zDP_ASITAB20SI 0, 8, 345, 122, 1157, 'Note Display String', 'Collections Note Display String', '', 0, 1, 5, '', 0, 0, 0, '', '', 'CN_Notes', @num OUT SELECT @num END

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(23000) Native Err:(2601) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert duplicate key row in object 'dbo.ASITAB20' with unique index 'AK2ASITAB20'. The duplicate key value is (0, 8, 1157, 122).*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(01000) Native Err:(3621) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) stmt(16578408):*/

*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) status(54):*/

SWSTATUS DUMP*/

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16618184):*/

{CALL DYNAMICS.dbo.zDP_ASITAB20L_1(0,8,-32768,0,8,32767)}

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16578408):*/

BEGIN DECLARE @num int EXEC DYNAMICS.dbo.zDP_ASITAB20SI 0, 8, 345, 123, 1157, 'Contact Person', 'Collections Contact Person', '', 0, 1, 5, '', 0, 0, 0, '', '', 'CN_Notes', @num OUT SELECT @num END

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(23000) Native Err:(2601) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert duplicate key row in object 'dbo.ASITAB20' with unique index 'AK2ASITAB20'. The duplicate key value is (0, 8, 1157, 123).*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(01000) Native Err:(3621) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) stmt(16578408):*/

*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) status(54):*/

SWSTATUS DUMP*/

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16618184):*/

{CALL DYNAMICS.dbo.zDP_ASITAB20L_1(0,8,-32768,0,8,32767)}

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16578408):*/

BEGIN DECLARE @num int EXEC DYNAMICS.dbo.zDP_ASITAB20SI 0, 8, 345, 124, 1157, 'Address Code', 'Collections Address Code', '', 0, 1, 5, '', 0, 0, 0, '', '', 'CN_Notes', @num OUT SELECT @num END

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(23000) Native Err:(2601) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert duplicate key row in object 'dbo.ASITAB20' with unique index 'AK2ASITAB20'. The duplicate key value is (0, 8, 1157, 124).*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(01000) Native Err:(3621) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) stmt(16578408):*/

*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) status(54):*/

SWSTATUS DUMP*/

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16618184):*/

{CALL DYNAMICS.dbo.zDP_ASITAB20L_1(0,8,-32768,0,8,32767)}

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16578408):*/

BEGIN DECLARE @num int EXEC DYNAMICS.dbo.zDP_ASITAB20SI 0, 8, 345, 125, 1157, 'User Defined 1', 'Collections User Defined 1', '', 0, 1, 5, '', 0, 0, 0, '', '', 'CN_Notes', @num OUT SELECT @num END

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(23000) Native Err:(2601) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert duplicate key row in object 'dbo.ASITAB20' with unique index 'AK2ASITAB20'. The duplicate key value is (0, 8, 1157, 125).*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(01000) Native Err:(3621) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) stmt(16578408):*/

*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) status(54):*/

SWSTATUS DUMP*/

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16618184):*/

{CALL DYNAMICS.dbo.zDP_ASITAB20L_1(0,8,-32768,0,8,32767)}

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16578408):*/

BEGIN DECLARE @num int EXEC DYNAMICS.dbo.zDP_ASITAB20SI 0, 8, 345, 126, 1157, 'User Defined 2', 'Collections User Defined 2', '', 0, 1, 5, '', 0, 0, 0, '', '', 'CN_Notes', @num OUT SELECT @num END

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(23000) Native Err:(2601) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert duplicate key row in object 'dbo.ASITAB20' with unique index 'AK2ASITAB20'. The duplicate key value is (0, 8, 1157, 126).*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(01000) Native Err:(3621) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) stmt(16578408):*/

*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) status(54):*/

SWSTATUS DUMP*/

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16618184):*/

{CALL DYNAMICS.dbo.zDP_ASITAB20L_1(0,8,-32768,0,8,32767)}

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16578408):*/

BEGIN DECLARE @num int EXEC DYNAMICS.dbo.zDP_ASITAB20SI 0, 8, 345, 127, 1157, 'User Defined Date 1', 'Collections User Defined Date 1', '', 0, 1, 3, '', 0, 0, 0, '', '', 'CN_Notes', @num OUT SELECT @num END

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(23000) Native Err:(2601) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert duplicate key row in object 'dbo.ASITAB20' with unique index 'AK2ASITAB20'. The duplicate key value is (0, 8, 1157, 127).*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(01000) Native Err:(3621) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) stmt(16578408):*/

*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) status(54):*/

SWSTATUS DUMP*/

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16618184):*/

{CALL DYNAMICS.dbo.zDP_ASITAB20L_1(0,8,-32768,0,8,32767)}

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16578408):*/

BEGIN DECLARE @num int EXEC DYNAMICS.dbo.zDP_ASITAB20SI 0, 8, 345, 128, 1157, 'Note Priority', 'Collections Note Priority', '', 0, 1, 7, '', 0, 0, 0, '', '', 'CN_Notes', @num OUT SELECT @num END

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(23000) Native Err:(2601) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert duplicate key row in object 'dbo.ASITAB20' with unique index 'AK2ASITAB20'. The duplicate key value is (0, 8, 1157, 128).*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(01000) Native Err:(3621) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) stmt(16578408):*/

*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) status(54):*/

SWSTATUS DUMP*/

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16618184):*/

{CALL DYNAMICS.dbo.zDP_ASITAB20L_1(0,8,-32768,0,8,32767)}

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16578408):*/

BEGIN DECLARE @num int EXEC DYNAMICS.dbo.zDP_ASITAB20SI 0, 8, 345, 129, 1157, 'Note Category', 'Collections Note Category', '', 0, 1, 5, '', 0, 0, 0, '', '', 'CN_Notes', @num OUT SELECT @num END

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(23000) Native Err:(2601) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert duplicate key row in object 'dbo.ASITAB20' with unique index 'AK2ASITAB20'. The duplicate key value is (0, 8, 1157, 129).*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(01000) Native Err:(3621) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) stmt(16578408):*/

*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) status(54):*/

SWSTATUS DUMP*/

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16618184):*/

{CALL DYNAMICS.dbo.zDP_ASITAB20L_1(0,8,-32768,0,8,32767)}

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16578408):*/

BEGIN DECLARE @num int EXEC DYNAMICS.dbo.zDP_ASITAB20SI 0, 8, 345, 130, 1157, 'NoteStatus', 'Collections NoteStatus', '', 0, 1, 7, '', 0, 0, 0, '', '', 'CN_Notes', @num OUT SELECT @num END

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(23000) Native Err:(2601) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert duplicate key row in object 'dbo.ASITAB20' with unique index 'AK2ASITAB20'. The duplicate key value is (0, 8, 1157, 130).*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(01000) Native Err:(3621) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) stmt(16578408):*/

*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) status(54):*/

SWSTATUS DUMP*/

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16618184):*/

{CALL DYNAMICS.dbo.zDP_ASITAB20L_1(0,8,-32768,0,8,32767)}

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16578408):*/

BEGIN DECLARE @num int EXEC DYNAMICS.dbo.zDP_ASITAB20SI 0, 8, 345, 131, 1157, 'Action Cancelled By', 'Collections Action Cancelled By', '', 0, 1, 5, '', 0, 0, 0, '', '', 'CN_Notes', @num OUT SELECT @num END

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(23000) Native Err:(2601) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert duplicate key row in object 'dbo.ASITAB20' with unique index 'AK2ASITAB20'. The duplicate key value is (0, 8, 1157, 131).*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(01000) Native Err:(3621) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) stmt(16578408):*/

*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) status(54):*/

SWSTATUS DUMP*/

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16618184):*/

{CALL DYNAMICS.dbo.zDP_ASITAB20L_1(0,8,-32768,0,8,32767)}

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16578408):*/

BEGIN DECLARE @num int EXEC DYNAMICS.dbo.zDP_ASITAB20SI 0, 8, 345, 132, 1157, 'Action Cancelled Date', 'Collections Action Cancelled Date', '', 0, 1, 3, '', 0, 0, 0, '', '', 'CN_Notes', @num OUT SELECT @num END

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(23000) Native Err:(2601) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert duplicate key row in object 'dbo.ASITAB20' with unique index 'AK2ASITAB20'. The duplicate key value is (0, 8, 1157, 132).*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(01000) Native Err:(3621) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) stmt(16578408):*/

*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) status(54):*/

SWSTATUS DUMP*/

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16693264):*/

{CALL DYNAMICS.dbo.zDP_ASIEXP60L_1(0,6,-32768,0,6,32767)}

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16578408):*/

BEGIN DECLARE @num int EXEC DYNAMICS.dbo.zDP_ASIEXP60SI 0, 6, 15, 'Collection Main', 37934584, 0, @num OUT SELECT @num END

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(23000) Native Err:(2601) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert duplicate key row in object 'dbo.ASIEXP60' with unique index 'AK2ASIEXP60'. The duplicate key value is (0, 6, 37934584).*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(01000) Native Err:(3621) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) stmt(16578408):*/

*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) status(54):*/

SWSTATUS DUMP*/

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16693264):*/

{CALL DYNAMICS.dbo.zDP_ASIEXP60L_1(0,6,-32768,0,6,32767)}

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16578408):*/

BEGIN DECLARE @num int EXEC DYNAMICS.dbo.zDP_ASIEXP60SI 0, 6, 15, 'New Collection Note', 37934591, 0, @num OUT SELECT @num END

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(23000) Native Err:(2601) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert duplicate key row in object 'dbo.ASIEXP60' with unique index 'AK2ASIEXP60'. The duplicate key value is (0, 6, 37934591).*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(01000) Native Err:(3621) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) stmt(16578408):*/

*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) status(54):*/

SWSTATUS DUMP*/

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16693264):*/

{CALL DYNAMICS.dbo.zDP_ASIEXP60L_1(0,6,-32768,0,6,32767)}

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16578408):*/

BEGIN DECLARE @num int EXEC DYNAMICS.dbo.zDP_ASIEXP60SI 0, 6, 15, 'View Collection Note', 37935573, 0, @num OUT SELECT @num END

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(23000) Native Err:(2601) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert duplicate key row in object 'dbo.ASIEXP60' with unique index 'AK2ASIEXP60'. The duplicate key value is (0, 6, 37935573).*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(01000) Native Err:(3621) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) stmt(16578408):*/

*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) status(54):*/

SWSTATUS DUMP*/

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16693264):*/

{CALL DYNAMICS.dbo.zDP_ASIEXP60L_1(0,8,-32768,0,8,32767)}

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16578408):*/

BEGIN DECLARE @num int EXEC DYNAMICS.dbo.zDP_ASIEXP60SI 0, 8, 12, 'Collection Main', 37934584, 0, @num OUT SELECT @num END

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(23000) Native Err:(2601) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert duplicate key row in object 'dbo.ASIEXP60' with unique index 'AK2ASIEXP60'. The duplicate key value is (0, 8, 37934584).*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(01000) Native Err:(3621) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) stmt(16578408):*/

*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) status(54):*/

SWSTATUS DUMP*/

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16693264):*/

{CALL DYNAMICS.dbo.zDP_ASIEXP60L_1(0,8,-32768,0,8,32767)}

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16578408):*/

BEGIN DECLARE @num int EXEC DYNAMICS.dbo.zDP_ASIEXP60SI 0, 8, 12, 'New Collection Note', 37934591, 0, @num OUT SELECT @num END

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(23000) Native Err:(2601) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert duplicate key row in object 'dbo.ASIEXP60' with unique index 'AK2ASIEXP60'. The duplicate key value is (0, 8, 37934591).*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(01000) Native Err:(3621) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) stmt(16578408):*/

*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) status(54):*/

SWSTATUS DUMP*/

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16693264):*/

{CALL DYNAMICS.dbo.zDP_ASIEXP60L_1(0,8,-32768,0,8,32767)}

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16578408):*/

BEGIN DECLARE @num int EXEC DYNAMICS.dbo.zDP_ASIEXP60SI 0, 8, 12, 'View Collection Note', 37935573, 0, @num OUT SELECT @num END

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(23000) Native Err:(2601) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert duplicate key row in object 'dbo.ASIEXP60' with unique index 'AK2ASIEXP60'. The duplicate key value is (0, 8, 37935573).*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(01000) Native Err:(3621) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) stmt(16578408):*/

*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) status(54):*/

SWSTATUS DUMP*/

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16618184):*/

{CALL DYNAMICS.dbo.zDP_ASITAB20L_1(0,8,-32768,0,8,32767)}

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16578408):*/

BEGIN DECLARE @num int EXEC DYNAMICS.dbo.zDP_ASITAB20SI 0, 8, 345, 200, 1157, 'Customer Number', 'Collections Customer Number', '', 0, 1, 5, '', 0, 0, 0, '', '', 'CN_Invoice_Notes_OPEN', @num OUT SELECT @num END

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(23000) Native Err:(2601) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert duplicate key row in object 'dbo.ASITAB20' with unique index 'AK2ASITAB20'. The duplicate key value is (0, 8, 1157, 200).*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(01000) Native Err:(3621) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) stmt(16578408):*/

*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) status(54):*/

SWSTATUS DUMP*/

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16618184):*/

{CALL DYNAMICS.dbo.zDP_ASITAB20L_1(0,8,-32768,0,8,32767)}

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16578408):*/

BEGIN DECLARE @num int EXEC DYNAMICS.dbo.zDP_ASITAB20SI 0, 8, 345, 201, 1157, 'Corporate Customer Number', 'Collections Corporate Customer Number', '', 0, 1, 5, '', 0, 0, 0, '', '', 'CN_Invoice_Notes_OPEN', @num OUT SELECT @num END

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(23000) Native Err:(2601) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert duplicate key row in object 'dbo.ASITAB20' with unique index 'AK2ASITAB20'. The duplicate key value is (0, 8, 1157, 201).*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(01000) Native Err:(3621) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) stmt(16578408):*/

*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) status(54):*/

SWSTATUS DUMP*/

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16618184):*/

{CALL DYNAMICS.dbo.zDP_ASITAB20L_1(0,8,-32768,0,8,32767)}

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16578408):*/

BEGIN DECLARE @num int EXEC DYNAMICS.dbo.zDP_ASITAB20SI 0, 8, 345, 202, 1157, 'RM Document Type-All', 'Collections RM Document Type-All', '', 0, 1, 2, '', 0, 0, 0, '', '', 'CN_Invoice_Notes_OPEN', @num OUT SELECT @num END

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(23000) Native Err:(2601) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert duplicate key row in object 'dbo.ASITAB20' with unique index 'AK2ASITAB20'. The duplicate key value is (0, 8, 1157, 202).*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(01000) Native Err:(3621) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) stmt(16578408):*/

*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) status(54):*/

SWSTATUS DUMP*/

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16618184):*/

{CALL DYNAMICS.dbo.zDP_ASITAB20L_1(0,8,-32768,0,8,32767)}

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16578408):*/

BEGIN DECLARE @num int EXEC DYNAMICS.dbo.zDP_ASITAB20SI 0, 8, 345, 203, 1157, 'Document Number', 'Collections Document Number', '', 0, 1, 5, '', 0, 0, 0, '', '', 'CN_Invoice_Notes_OPEN', @num OUT SELECT @num END

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(23000) Native Err:(2601) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert duplicate key row in object 'dbo.ASITAB20' with unique index 'AK2ASITAB20'. The duplicate key value is (0, 8, 1157, 203).*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(01000) Native Err:(3621) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) stmt(16578408):*/

*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) status(54):*/

SWSTATUS DUMP*/

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16618184):*/

{CALL DYNAMICS.dbo.zDP_ASITAB20L_1(0,8,-32768,0,8,32767)}

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16578408):*/

BEGIN DECLARE @num int EXEC DYNAMICS.dbo.zDP_ASITAB20SI 0, 8, 345, 204, 1157, 'Note Index', 'Collections Note Index', '', 0, 1, 2, '', 0, 0, 0, '', '', 'CN_Invoice_Notes_OPEN', @num OUT SELECT @num END

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(23000) Native Err:(2601) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert duplicate key row in object 'dbo.ASITAB20' with unique index 'AK2ASITAB20'. The duplicate key value is (0, 8, 1157, 204).*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(01000) Native Err:(3621) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) stmt(16578408):*/

*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) status(54):*/

SWSTATUS DUMP*/

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16618184):*/

{CALL DYNAMICS.dbo.zDP_ASITAB20L_1(0,8,-32768,0,8,32767)}

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16578408):*/

BEGIN DECLARE @num int EXEC DYNAMICS.dbo.zDP_ASITAB20SI 0, 8, 345, 205, 1157, 'Action Type', 'Collections Action Type', '', 0, 1, 7, '', 0, 0, 0, '', '', 'CN_Invoice_Notes_OPEN', @num OUT SELECT @num END

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(23000) Native Err:(2601) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert duplicate key row in object 'dbo.ASITAB20' with unique index 'AK2ASITAB20'. The duplicate key value is (0, 8, 1157, 205).*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(01000) Native Err:(3621) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) stmt(16578408):*/

*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) status(54):*/

SWSTATUS DUMP*/

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16618184):*/

{CALL DYNAMICS.dbo.zDP_ASITAB20L_1(0,8,-32768,0,8,32767)}

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16578408):*/

BEGIN DECLARE @num int EXEC DYNAMICS.dbo.zDP_ASITAB20SI 0, 8, 345, 206, 1157, 'Action Amount', 'Collections Action Amount', '', 0, 1, 4, '', 0, 0, 0, '', '', 'CN_Invoice_Notes_OPEN', @num OUT SELECT @num END

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(23000) Native Err:(2601) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert duplicate key row in object 'dbo.ASITAB20' with unique index 'AK2ASITAB20'. The duplicate key value is (0, 8, 1157, 206).*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(01000) Native Err:(3621) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) stmt(16578408):*/

*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) status(54):*/

SWSTATUS DUMP*/

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16618184):*/

{CALL DYNAMICS.dbo.zDP_ASITAB20L_1(0,8,-32768,0,8,32767)}

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16578408):*/

BEGIN DECLARE @num int EXEC DYNAMICS.dbo.zDP_ASITAB20SI 0, 8, 345, 207, 1157, 'Current Trx Amount', 'Collections Current Trx Amount', '', 0, 1, 4, '', 0, 0, 0, '', '', 'CN_Invoice_Notes_OPEN', @num OUT SELECT @num END

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(23000) Native Err:(2601) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert duplicate key row in object 'dbo.ASITAB20' with unique index 'AK2ASITAB20'. The duplicate key value is (0, 8, 1157, 207).*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(01000) Native Err:(3621) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) stmt(16578408):*/

*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) status(54):*/

SWSTATUS DUMP*/

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16618184):*/

{CALL DYNAMICS.dbo.zDP_ASITAB20L_1(0,8,-32768,0,8,32767)}

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16578408):*/

BEGIN DECLARE @num int EXEC DYNAMICS.dbo.zDP_ASITAB20SI 0, 8, 345, 208, 1157, 'Currency ID', 'Collections Currency ID', '', 0, 1, 5, '', 0, 0, 0, '', '', 'CN_Invoice_Notes_OPEN', @num OUT SELECT @num END

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(23000) Native Err:(2601) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert duplicate key row in object 'dbo.ASITAB20' with unique index 'AK2ASITAB20'. The duplicate key value is (0, 8, 1157, 208).*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(01000) Native Err:(3621) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) stmt(16578408):*/

*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) status(54):*/

SWSTATUS DUMP*/

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16618184):*/

{CALL DYNAMICS.dbo.zDP_ASITAB20L_1(0,8,-32768,0,8,32767)}

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16578408):*/

BEGIN DECLARE @num int EXEC DYNAMICS.dbo.zDP_ASITAB20SI 0, 8, 345, 209, 1157, 'Currency Index', 'Collections Currency Index', '', 0, 1, 2, '', 0, 0, 0, '', '', 'CN_Invoice_Notes_OPEN', @num OUT SELECT @num END

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(23000) Native Err:(2601) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert duplicate key row in object 'dbo.ASITAB20' with unique index 'AK2ASITAB20'. The duplicate key value is (0, 8, 1157, 209).*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(01000) Native Err:(3621) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) stmt(16578408):*/

*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) status(54):*/

SWSTATUS DUMP*/

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16618184):*/

{CALL DYNAMICS.dbo.zDP_ASITAB20L_1(0,8,-32768,0,8,32767)}

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16578408):*/

BEGIN DECLARE @num int EXEC DYNAMICS.dbo.zDP_ASITAB20SI 0, 8, 345, 210, 1157, 'Aging Bucket', 'Collections Aging Bucket', '', 0, 1, 2, '', 0, 0, 0, '', '', 'CN_Invoice_Notes_OPEN', @num OUT SELECT @num END

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(23000) Native Err:(2601) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert duplicate key row in object 'dbo.ASITAB20' with unique index 'AK2ASITAB20'. The duplicate key value is (0, 8, 1157, 210).*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(01000) Native Err:(3621) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) stmt(16578408):*/

*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) status(54):*/

SWSTATUS DUMP*/

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16618184):*/

{CALL DYNAMICS.dbo.zDP_ASITAB20L_1(0,8,-32768,0,8,32767)}

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16578408):*/

BEGIN DECLARE @num int EXEC DYNAMICS.dbo.zDP_ASITAB20SI 0, 8, 345, 101, 1157, 'Customer Number', 'Collections Customer Number', '', 0, 1, 5, '', 0, 0, 0, '', '', 'CN_Notes', @num OUT SELECT @num END

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(23000) Native Err:(2601) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert duplicate key row in object 'dbo.ASITAB20' with unique index 'AK2ASITAB20'. The duplicate key value is (0, 8, 1157, 101).*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(01000) Native Err:(3621) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) stmt(16578408):*/

*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) status(54):*/

SWSTATUS DUMP*/

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16618184):*/

{CALL DYNAMICS.dbo.zDP_ASITAB20L_1(0,8,-32768,0,8,32767)}

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16578408):*/

BEGIN DECLARE @num int EXEC DYNAMICS.dbo.zDP_ASITAB20SI 0, 8, 345, 102, 1157, 'Corporate Customer Number', 'Collections Corporate Customer Number', '', 0, 1, 5, '', 0, 0, 0, '', '', 'CN_Notes', @num OUT SELECT @num END

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(23000) Native Err:(2601) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert duplicate key row in object 'dbo.ASITAB20' with unique index 'AK2ASITAB20'. The duplicate key value is (0, 8, 1157, 102).*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(01000) Native Err:(3621) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) stmt(16578408):*/

*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) status(54):*/

SWSTATUS DUMP*/

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16618184):*/

{CALL DYNAMICS.dbo.zDP_ASITAB20L_1(0,8,-32768,0,8,32767)}

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16578408):*/

BEGIN DECLARE @num int EXEC DYNAMICS.dbo.zDP_ASITAB20SI 0, 8, 345, 103, 1157, 'Date', 'Collections Date', '', 0, 1, 3, '', 0, 0, 0, '', '', 'CN_Notes', @num OUT SELECT @num END

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(23000) Native Err:(2601) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert duplicate key row in object 'dbo.ASITAB20' with unique index 'AK2ASITAB20'. The duplicate key value is (0, 8, 1157, 103).*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(01000) Native Err:(3621) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) stmt(16578408):*/

*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) status(54):*/

SWSTATUS DUMP*/

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16618184):*/

{CALL DYNAMICS.dbo.zDP_ASITAB20L_1(0,8,-32768,0,8,32767)}

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16578408):*/

BEGIN DECLARE @num int EXEC DYNAMICS.dbo.zDP_ASITAB20SI 0, 8, 345, 104, 1157, 'Contact Date', 'Collections Contact Date', '', 0, 1, 3, '', 0, 0, 0, '', '', 'CN_Notes', @num OUT SELECT @num END

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(23000) Native Err:(2601) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert duplicate key row in object 'dbo.ASITAB20' with unique index 'AK2ASITAB20'. The duplicate key value is (0, 8, 1157, 104).*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(01000) Native Err:(3621) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) stmt(16578408):*/

*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) status(54):*/

SWSTATUS DUMP*/

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16618184):*/

{CALL DYNAMICS.dbo.zDP_ASITAB20L_1(0,8,-32768,0,8,32767)}

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16578408):*/

BEGIN DECLARE @num int EXEC DYNAMICS.dbo.zDP_ASITAB20SI 0, 8, 345, 105, 1157, 'Time', 'Collections Time', '', 0, 1, 12, '', 0, 0, 0, '', '', 'CN_Notes', @num OUT SELECT @num END

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(23000) Native Err:(2601) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert duplicate key row in object 'dbo.ASITAB20' with unique index 'AK2ASITAB20'. The duplicate key value is (0, 8, 1157, 105).*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(01000) Native Err:(3621) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) stmt(16578408):*/

*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) status(54):*/

SWSTATUS DUMP*/

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16618184):*/

{CALL DYNAMICS.dbo.zDP_ASITAB20L_1(0,8,-32768,0,8,32767)}

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16578408):*/

BEGIN DECLARE @num int EXEC DYNAMICS.dbo.zDP_ASITAB20SI 0, 8, 345, 106, 1157, 'Contact Time', 'Collections Contact Time', '', 0, 1, 12, '', 0, 0, 0, '', '', 'CN_Notes', @num OUT SELECT @num END

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(23000) Native Err:(2601) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert duplicate key row in object 'dbo.ASITAB20' with unique index 'AK2ASITAB20'. The duplicate key value is (0, 8, 1157, 106).*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(01000) Native Err:(3621) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) stmt(16578408):*/

*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) status(54):*/

SWSTATUS DUMP*/

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16618184):*/

{CALL DYNAMICS.dbo.zDP_ASITAB20L_1(0,8,-32768,0,8,32767)}

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16578408):*/

BEGIN DECLARE @num int EXEC DYNAMICS.dbo.zDP_ASITAB20SI 0, 8, 345, 107, 1157, 'Note Index', 'Collections Note Index', '', 0, 1, 2, '', 0, 0, 0, '', '', 'CN_Notes', @num OUT SELECT @num END

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(23000) Native Err:(2601) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert duplicate key row in object 'dbo.ASITAB20' with unique index 'AK2ASITAB20'. The duplicate key value is (0, 8, 1157, 107).*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(01000) Native Err:(3621) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) stmt(16578408):*/

*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) status(54):*/

SWSTATUS DUMP*/

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16618184):*/

{CALL DYNAMICS.dbo.zDP_ASITAB20L_1(0,8,-32768,0,8,32767)}

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16578408):*/

BEGIN DECLARE @num int EXEC DYNAMICS.dbo.zDP_ASITAB20SI 0, 8, 345, 108, 1157, 'CN Revision Number', 'Collections CN Revision Number', '', 0, 1, 2, '', 0, 0, 0, '', '', 'CN_Notes', @num OUT SELECT @num END

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(23000) Native Err:(2601) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert duplicate key row in object 'dbo.ASITAB20' with unique index 'AK2ASITAB20'. The duplicate key value is (0, 8, 1157, 108).*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(01000) Native Err:(3621) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) stmt(16578408):*/

*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) status(54):*/

SWSTATUS DUMP*/

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16618184):*/

{CALL DYNAMICS.dbo.zDP_ASITAB20L_1(0,8,-32768,0,8,32767)}

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16578408):*/

BEGIN DECLARE @num int EXEC DYNAMICS.dbo.zDP_ASITAB20SI 0, 8, 345, 109, 1157, 'CN Group Note', 'Collections CN Group Note', '', 0, 1, 6, '', 0, 0, 0, '', '', 'CN_Notes', @num OUT SELECT @num END

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(23000) Native Err:(2601) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert duplicate key row in object 'dbo.ASITAB20' with unique index 'AK2ASITAB20'. The duplicate key value is (0, 8, 1157, 109).*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(01000) Native Err:(3621) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) stmt(16578408):*/

*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) status(54):*/

SWSTATUS DUMP*/

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16618184):*/

{CALL DYNAMICS.dbo.zDP_ASITAB20L_1(0,8,-32768,0,8,32767)}

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16578408):*/

BEGIN DECLARE @num int EXEC DYNAMICS.dbo.zDP_ASITAB20SI 0, 8, 345, 110, 1157, 'Caller ID String', 'Collections Caller ID String', '', 0, 1, 5, '', 0, 0, 0, '', '', 'CN_Notes', @num OUT SELECT @num END

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(23000) Native Err:(2601) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert duplicate key row in object 'dbo.ASITAB20' with unique index 'AK2ASITAB20'. The duplicate key value is (0, 8, 1157, 110).*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(01000) Native Err:(3621) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) stmt(16578408):*/

*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) status(54):*/

SWSTATUS DUMP*/

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16618184):*/

{CALL DYNAMICS.dbo.zDP_ASITAB20L_1(0,8,-32768,0,8,32767)}

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16578408):*/

BEGIN DECLARE @num int EXEC DYNAMICS.dbo.zDP_ASITAB20SI 0, 8, 345, 111, 1157, 'Action Promised', 'Collections Action Promised', '', 0, 1, 5, '', 0, 0, 0, '', '', 'CN_Notes', @num OUT SELECT @num END

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(23000) Native Err:(2601) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert duplicate key row in object 'dbo.ASITAB20' with unique index 'AK2ASITAB20'. The duplicate key value is (0, 8, 1157, 111).*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(01000) Native Err:(3621) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) stmt(16578408):*/

*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) status(54):*/

SWSTATUS DUMP*/

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16618184):*/

{CALL DYNAMICS.dbo.zDP_ASITAB20L_1(0,8,-32768,0,8,32767)}

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16578408):*/

BEGIN DECLARE @num int EXEC DYNAMICS.dbo.zDP_ASITAB20SI 0, 8, 345, 112, 1157, 'Action Type', 'Collections Action Type', '', 0, 1, 7, '', 0, 0, 0, '', '', 'CN_Notes', @num OUT SELECT @num END

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(23000) Native Err:(2601) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert duplicate key row in object 'dbo.ASITAB20' with unique index 'AK2ASITAB20'. The duplicate key value is (0, 8, 1157, 112).*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(01000) Native Err:(3621) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) stmt(16578408):*/

*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) status(54):*/

SWSTATUS DUMP*/

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16618184):*/

{CALL DYNAMICS.dbo.zDP_ASITAB20L_1(0,8,-32768,0,8,32767)}

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16578408):*/

BEGIN DECLARE @num int EXEC DYNAMICS.dbo.zDP_ASITAB20SI 0, 8, 345, 113, 1157, 'Action Date', 'Collections Action Date', '', 0, 1, 3, '', 0, 0, 0, '', '', 'CN_Notes', @num OUT SELECT @num END

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(23000) Native Err:(2601) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert duplicate key row in object 'dbo.ASITAB20' with unique index 'AK2ASITAB20'. The duplicate key value is (0, 8, 1157, 113).*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(01000) Native Err:(3621) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) stmt(16578408):*/

*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) status(54):*/

SWSTATUS DUMP*/

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16618184):*/

{CALL DYNAMICS.dbo.zDP_ASITAB20L_1(0,8,-32768,0,8,32767)}

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16578408):*/

BEGIN DECLARE @num int EXEC DYNAMICS.dbo.zDP_ASITAB20SI 0, 8, 345, 114, 1157, 'Action Assigned To', 'Collections Action Assigned To', '', 0, 1, 5, '', 0, 0, 0, '', '', 'CN_Notes', @num OUT SELECT @num END

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(23000) Native Err:(2601) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert duplicate key row in object 'dbo.ASITAB20' with unique index 'AK2ASITAB20'. The duplicate key value is (0, 8, 1157, 114).*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(01000) Native Err:(3621) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) stmt(16578408):*/

*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) status(54):*/

SWSTATUS DUMP*/

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16618184):*/

{CALL DYNAMICS.dbo.zDP_ASITAB20L_1(0,8,-32768,0,8,32767)}

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16578408):*/

BEGIN DECLARE @num int EXEC DYNAMICS.dbo.zDP_ASITAB20SI 0, 8, 345, 115, 1157, 'Action Completed', 'Collections Action Completed', '', 0, 1, 6, '', 0, 0, 0, '', '', 'CN_Notes', @num OUT SELECT @num END

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(23000) Native Err:(2601) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert duplicate key row in object 'dbo.ASITAB20' with unique index 'AK2ASITAB20'. The duplicate key value is (0, 8, 1157, 115).*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(01000) Native Err:(3621) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) stmt(16578408):*/

*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) status(54):*/

SWSTATUS DUMP*/

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16618184):*/

{CALL DYNAMICS.dbo.zDP_ASITAB20L_1(0,8,-32768,0,8,32767)}

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16578408):*/

BEGIN DECLARE @num int EXEC DYNAMICS.dbo.zDP_ASITAB20SI 0, 8, 345, 116, 1157, 'Action Completed Sort By', 'Collections Action Completed Sort By', '', 0, 1, 6, '', 0, 0, 0, '', '', 'CN_Notes', @num OUT SELECT @num END

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(23000) Native Err:(2601) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert duplicate key row in object 'dbo.ASITAB20' with unique index 'AK2ASITAB20'. The duplicate key value is (0, 8, 1157, 116).*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(01000) Native Err:(3621) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) stmt(16578408):*/

*/

/*

/* Date: 07/15/2015 Time: 10:28:43

SQLSTATE:(00000) Native Err:(3621) status(54):*/

SWSTATUS DUMP*/

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16618184):*/

{CALL DYNAMICS.dbo.zDP_ASITAB20L_1(0,8,-32768,0,8,32767)}

 

/* Date: 07/15/2015 Time: 10:28:43

stmt(16578408):*/

BEGIN DECLARE @num int EXEC DYNAMICS.dbo.zDP_ASITAB20SI 0, 8, 345, 117, 1157, 'Action Completed Date', 'Collections Action Completed Date', '', 0, 1, 3, '', 0, 0, 0, '', '', 'CN_Notes', @num OUT SELECT @num END

/*

/* Date: 07/15/2015 Time: 10:28:44

SQLSTATE:(23000) Native Err:(2601) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert duplicate key row in object 'dbo.ASITAB20' with unique index 'AK2ASITAB20'. The duplicate key value is (0, 8, 1157, 117).*/

/*

/* Date: 07/15/2015 Time: 10:28:44

SQLSTATE:(01000) Native Err:(3621) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.*/

/*

/* Date: 07/15/2015 Time: 10:28:44

SQLSTATE:(00000) Native Err:(3621) stmt(16578408):*/

*/

/*

/* Date: 07/15/2015 Time: 10:28:44

SQLSTATE:(00000) Native Err:(3621) status(54):*/

SWSTATUS DUMP*/

 

/* Date: 07/15/2015 Time: 10:28:44

stmt(16618184):*/

{CALL DYNAMICS.dbo.zDP_ASITAB20L_1(0,8,-32768,0,8,32767)}

 

/* Date: 07/15/2015 Time: 10:28:44

stmt(16578408):*/

BEGIN DECLARE @num int EXEC DYNAMICS.dbo.zDP_ASITAB20SI 0, 8, 345, 118, 1157, 'Action Completed Time', 'Collections Action Completed Time', '', 0, 1, 12, '', 0, 0, 0, '', '', 'CN_Notes', @num OUT SELECT @num END

/*

/* Date: 07/15/2015 Time: 10:28:44

SQLSTATE:(23000) Native Err:(2601) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert duplicate key row in object 'dbo.ASITAB20' with unique index 'AK2ASITAB20'. The duplicate key value is (0, 8, 1157, 118).*/

/*

/* Date: 07/15/2015 Time: 10:28:44

SQLSTATE:(01000) Native Err:(3621) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.*/

/*

/* Date: 07/15/2015 Time: 10:28:44

SQLSTATE:(00000) Native Err:(3621) stmt(16578408):*/

*/

/*

/* Date: 07/15/2015 Time: 10:28:44

SQLSTATE:(00000) Native Err:(3621) status(54):*/

SWSTATUS DUMP*/

 

/* Date: 07/15/2015 Time: 10:28:44

stmt(16618184):*/

{CALL DYNAMICS.dbo.zDP_ASITAB20L_1(0,8,-32768,0,8,32767)}

 

/* Date: 07/15/2015 Time: 10:28:44

stmt(16578408):*/

BEGIN DECLARE @num int EXEC DYNAMICS.dbo.zDP_ASITAB20SI 0, 8, 345, 119, 1157, 'Amount Promised', 'Collections Amount Promised', '', 0, 1, 4, '', 0, 0, 0, '', '', 'CN_Notes', @num OUT SELECT @num END

/*

/* Date: 07/15/2015 Time: 10:28:44

SQLSTATE:(23000) Native Err:(2601) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert duplicate key row in object 'dbo.ASITAB20' with unique index 'AK2ASITAB20'. The duplicate key value is (0, 8, 1157, 119).*/

/*

/* Date: 07/15/2015 Time: 10:28:44

SQLSTATE:(01000) Native Err:(3621) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.*/

/*

/* Date: 07/15/2015 Time: 10:28:44

SQLSTATE:(00000) Native Err:(3621) stmt(16578408):*/

*/

/*

/* Date: 07/15/2015 Time: 10:28:44

SQLSTATE:(00000) Native Err:(3621) status(54):*/

SWSTATUS DUMP*/

 

/* Date: 07/15/2015 Time: 10:28:44

stmt(16618184):*/

{CALL DYNAMICS.dbo.zDP_ASITAB20L_1(0,8,-32768,0,8,32767)}

 

/* Date: 07/15/2015 Time: 10:28:44

stmt(16578408):*/

BEGIN DECLARE @num int EXEC DYNAMICS.dbo.zDP_ASITAB20SI 0, 8, 345, 120, 1157, 'Amount Received', 'Collections Amount Received', '', 0, 1, 4, '', 0, 0, 0, '', '', 'CN_Notes', @num OUT SELECT @num END

/*

/* Date: 07/15/2015 Time: 10:28:44

SQLSTATE:(23000) Native Err:(2601) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert duplicate key row in object 'dbo.ASITAB20' with unique index 'AK2ASITAB20'. The duplicate key value is (0, 8, 1157, 120).*/

/*

/* Date: 07/15/2015 Time: 10:28:44

SQLSTATE:(01000) Native Err:(3621) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.*/

/*

/* Date: 07/15/2015 Time: 10:28:44

SQLSTATE:(00000) Native Err:(3621) stmt(16578408):*/

*/

/*

/* Date: 07/15/2015 Time: 10:28:44

SQLSTATE:(00000) Native Err:(3621) status(54):*/

SWSTATUS DUMP*/

 

/* Date: 07/15/2015 Time: 10:28:44

stmt(16618184):*/

{CALL DYNAMICS.dbo.zDP_ASITAB20L_1(0,8,-32768,0,8,32767)}

 

/* Date: 07/15/2015 Time: 10:28:44

stmt(16578408):*/

BEGIN DECLARE @num int EXEC DYNAMICS.dbo.zDP_ASITAB20SI 0, 8, 345, 121, 1157, 'User ID', 'Collector', '', 0, 1, 5, '', 0, 0, 0, '', '', 'CN_Notes', @num OUT SELECT @num END

/*

/* Date: 07/15/2015 Time: 10:28:44

SQLSTATE:(23000) Native Err:(2601) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert duplicate key row in object 'dbo.ASITAB20' with unique index 'AK2ASITAB20'. The duplicate key value is (0, 8, 1157, 121).*/

/*

/* Date: 07/15/2015 Time: 10:28:44

SQLSTATE:(01000) Native Err:(3621) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.*/

/*

/* Date: 07/15/2015 Time: 10:28:44

SQLSTATE:(00000) Native Err:(3621) stmt(16578408):*/

*/

/*

/* Date: 07/15/2015 Time: 10:28:44

SQLSTATE:(00000) Native Err:(3621) status(54):*/

SWSTATUS DUMP*/

 

/* Date: 07/15/2015 Time: 10:28:44

stmt(16618184):*/

{CALL DYNAMICS.dbo.zDP_ASITAB20L_1(0,8,-32768,0,8,32767)}

 

/* Date: 07/15/2015 Time: 10:28:44

stmt(16578408):*/

BEGIN DECLARE @num int EXEC DYNAMICS.dbo.zDP_ASITAB20SI 0, 8, 345, 122, 1157, 'Note Display String', 'Collections Note Display String', '', 0, 1, 5, '', 0, 0, 0, '', '', 'CN_Notes', @num OUT SELECT @num END

/*

/* Date: 07/15/2015 Time: 10:28:44

SQLSTATE:(23000) Native Err:(2601) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert duplicate key row in object 'dbo.ASITAB20' with unique index 'AK2ASITAB20'. The duplicate key value is (0, 8, 1157, 122).*/

/*

/* Date: 07/15/2015 Time: 10:28:44

SQLSTATE:(01000) Native Err:(3621) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.*/

/*

/* Date: 07/15/2015 Time: 10:28:44

SQLSTATE:(00000) Native Err:(3621) stmt(16578408):*/

*/

/*

/* Date: 07/15/2015 Time: 10:28:44

SQLSTATE:(00000) Native Err:(3621) status(54):*/

SWSTATUS DUMP*/

 

/* Date: 07/15/2015 Time: 10:28:44

stmt(16618184):*/

{CALL DYNAMICS.dbo.zDP_ASITAB20L_1(0,8,-32768,0,8,32767)}

 

/* Date: 07/15/2015 Time: 10:28:44

stmt(16578408):*/

BEGIN DECLARE @num int EXEC DYNAMICS.dbo.zDP_ASITAB20SI 0, 8, 345, 123, 1157, 'Contact Person', 'Collections Contact Person', '', 0, 1, 5, '', 0, 0, 0, '', '', 'CN_Notes', @num OUT SELECT @num END

/*

/* Date: 07/15/2015 Time: 10:28:44

SQLSTATE:(23000) Native Err:(2601) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert duplicate key row in object 'dbo.ASITAB20' with unique index 'AK2ASITAB20'. The duplicate key value is (0, 8, 1157, 123).*/

/*

/* Date: 07/15/2015 Time: 10:28:44

SQLSTATE:(01000) Native Err:(3621) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.*/

/*

/* Date: 07/15/2015 Time: 10:28:44

SQLSTATE:(00000) Native Err:(3621) stmt(16578408):*/

*/

/*

/* Date: 07/15/2015 Time: 10:28:44

SQLSTATE:(00000) Native Err:(3621) status(54):*/

SWSTATUS DUMP*/

 

/* Date: 07/15/2015 Time: 10:28:44

stmt(16618184):*/

{CALL DYNAMICS.dbo.zDP_ASITAB20L_1(0,8,-32768,0,8,32767)}

 

/* Date: 07/15/2015 Time: 10:28:44

stmt(16578408):*/

BEGIN DECLARE @num int EXEC DYNAMICS.dbo.zDP_ASITAB20SI 0, 8, 345, 124, 1157, 'Address Code', 'Collections Address Code', '', 0, 1, 5, '', 0, 0, 0, '', '', 'CN_Notes', @num OUT SELECT @num END

/*

/* Date: 07/15/2015 Time: 10:28:44

SQLSTATE:(23000) Native Err:(2601) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert duplicate key row in object 'dbo.ASITAB20' with unique index 'AK2ASITAB20'. The duplicate key value is (0, 8, 1157, 124).*/

/*

/* Date: 07/15/2015 Time: 10:28:44

SQLSTATE:(01000) Native Err:(3621) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.*/

/*

/* Date: 07/15/2015 Time: 10:28:44

SQLSTATE:(00000) Native Err:(3621) stmt(16578408):*/

*/

/*

/* Date: 07/15/2015 Time: 10:28:44

SQLSTATE:(00000) Native Err:(3621) status(54):*/

SWSTATUS DUMP*/

 

/* Date: 07/15/2015 Time: 10:28:44

stmt(16618184):*/

{CALL DYNAMICS.dbo.zDP_ASITAB20L_1(0,8,-32768,0,8,32767)}

 

/* Date: 07/15/2015 Time: 10:28:44

stmt(16578408):*/

BEGIN DECLARE @num int EXEC DYNAMICS.dbo.zDP_ASITAB20SI 0, 8, 345, 125, 1157, 'User Defined 1', 'Collections User Defined 1', '', 0, 1, 5, '', 0, 0, 0, '', '', 'CN_Notes', @num OUT SELECT @num END

/*

/* Date: 07/15/2015 Time: 10:28:44

SQLSTATE:(23000) Native Err:(2601) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert duplicate key row in object 'dbo.ASITAB20' with unique index 'AK2ASITAB20'. The duplicate key value is (0, 8, 1157, 125).*/

/*

/* Date: 07/15/2015 Time: 10:28:44

SQLSTATE:(01000) Native Err:(3621) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.*/

/*

/* Date: 07/15/2015 Time: 10:28:44

SQLSTATE:(00000) Native Err:(3621) stmt(16578408):*/

*/

/*

/* Date: 07/15/2015 Time: 10:28:44

SQLSTATE:(00000) Native Err:(3621) status(54):*/

SWSTATUS DUMP*/

 

/* Date: 07/15/2015 Time: 10:28:44

stmt(16618184):*/

{CALL DYNAMICS.dbo.zDP_ASITAB20L_1(0,8,-32768,0,8,32767)}

 

/* Date: 07/15/2015 Time: 10:28:44

stmt(16578408):*/

BEGIN DECLARE @num int EXEC DYNAMICS.dbo.zDP_ASITAB20SI 0, 8, 345, 126, 1157, 'User Defined 2', 'Collections User Defined 2', '', 0, 1, 5, '', 0, 0, 0, '', '', 'CN_Notes', @num OUT SELECT @num END

/*

/* Date: 07/15/2015 Time: 10:28:44

SQLSTATE:(23000) Native Err:(2601) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert duplicate key row in object 'dbo.ASITAB20' with unique index 'AK2ASITAB20'. The duplicate key value is (0, 8, 1157, 126).*/

/*

/* Date: 07/15/2015 Time: 10:28:44

SQLSTATE:(01000) Native Err:(3621) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.*/

/*

/* Date: 07/15/2015 Time: 10:28:44

SQLSTATE:(00000) Native Err:(3621) stmt(16578408):*/

*/

/*

/* Date: 07/15/2015 Time: 10:28:44

SQLSTATE:(00000) Native Err:(3621) status(54):*/

SWSTATUS DUMP*/

 

/* Date: 07/15/2015 Time: 10:28:44

stmt(16618184):*/

{CALL DYNAMICS.dbo.zDP_ASITAB20L_1(0,8,-32768,0,8,32767)}

 

/* Date: 07/15/2015 Time: 10:28:44

stmt(16578408):*/

BEGIN DECLARE @num int EXEC DYNAMICS.dbo.zDP_ASITAB20SI 0, 8, 345, 127, 1157, 'User Defined Date 1', 'Collections User Defined Date 1', '', 0, 1, 3, '', 0, 0, 0, '', '', 'CN_Notes', @num OUT SELECT @num END

/*

/* Date: 07/15/2015 Time: 10:28:44

SQLSTATE:(23000) Native Err:(2601) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert duplicate key row in object 'dbo.ASITAB20' with unique index 'AK2ASITAB20'. The duplicate key value is (0, 8, 1157, 127).*/

/*

/* Date: 07/15/2015 Time: 10:28:44

SQLSTATE:(01000) Native Err:(3621) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.*/

/*

/* Date: 07/15/2015 Time: 10:28:44

SQLSTATE:(00000) Native Err:(3621) stmt(16578408):*/

*/

/*

/* Date: 07/15/2015 Time: 10:28:44

SQLSTATE:(00000) Native Err:(3621) status(54):*/

SWSTATUS DUMP*/

 

/* Date: 07/15/2015 Time: 10:28:44

stmt(16618184):*/

{CALL DYNAMICS.dbo.zDP_ASITAB20L_1(0,8,-32768,0,8,32767)}

 

/* Date: 07/15/2015 Time: 10:28:44

stmt(16578408):*/

BEGIN DECLARE @num int EXEC DYNAMICS.dbo.zDP_ASITAB20SI 0, 8, 345, 128, 1157, 'Note Priority', 'Collections Note Priority', '', 0, 1, 7, '', 0, 0, 0, '', '', 'CN_Notes', @num OUT SELECT @num END

/*

/* Date: 07/15/2015 Time: 10:28:44

SQLSTATE:(23000) Native Err:(2601) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert duplicate key row in object 'dbo.ASITAB20' with unique index 'AK2ASITAB20'. The duplicate key value is (0, 8, 1157, 128).*/

/*

/* Date: 07/15/2015 Time: 10:28:44

SQLSTATE:(01000) Native Err:(3621) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.*/

/*

/* Date: 07/15/2015 Time: 10:28:44

SQLSTATE:(00000) Native Err:(3621) stmt(16578408):*/

*/

/*

/* Date: 07/15/2015 Time: 10:28:44

SQLSTATE:(00000) Native Err:(3621) status(54):*/

SWSTATUS DUMP*/

 

/* Date: 07/15/2015 Time: 10:28:44

stmt(16618184):*/

{CALL DYNAMICS.dbo.zDP_ASITAB20L_1(0,8,-32768,0,8,32767)}

 

/* Date: 07/15/2015 Time: 10:28:44

stmt(16578408):*/

BEGIN DECLARE @num int EXEC DYNAMICS.dbo.zDP_ASITAB20SI 0, 8, 345, 129, 1157, 'Note Category', 'Collections Note Category', '', 0, 1, 5, '', 0, 0, 0, '', '', 'CN_Notes', @num OUT SELECT @num END

/*

/* Date: 07/15/2015 Time: 10:28:44

SQLSTATE:(23000) Native Err:(2601) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert duplicate key row in object 'dbo.ASITAB20' with unique index 'AK2ASITAB20'. The duplicate key value is (0, 8, 1157, 129).*/

/*

/* Date: 07/15/2015 Time: 10:28:44

SQLSTATE:(01000) Native Err:(3621) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.*/

/*

/* Date: 07/15/2015 Time: 10:28:44

SQLSTATE:(00000) Native Err:(3621) stmt(16578408):*/

*/

/*

/* Date: 07/15/2015 Time: 10:28:44

SQLSTATE:(00000) Native Err:(3621) status(54):*/

SWSTATUS DUMP*/

 

/* Date: 07/15/2015 Time: 10:28:44

stmt(16618184):*/

{CALL DYNAMICS.dbo.zDP_ASITAB20L_1(0,8,-32768,0,8,32767)}

 

/* Date: 07/15/2015 Time: 10:28:44

stmt(16578408):*/

BEGIN DECLARE @num int EXEC DYNAMICS.dbo.zDP_ASITAB20SI 0, 8, 345, 130, 1157, 'NoteStatus', 'Collections NoteStatus', '', 0, 1, 7, '', 0, 0, 0, '', '', 'CN_Notes', @num OUT SELECT @num END

/*

/* Date: 07/15/2015 Time: 10:28:44

SQLSTATE:(23000) Native Err:(2601) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert duplicate key row in object 'dbo.ASITAB20' with unique index 'AK2ASITAB20'. The duplicate key value is (0, 8, 1157, 130).*/

/*

/* Date: 07/15/2015 Time: 10:28:44

SQLSTATE:(01000) Native Err:(3621) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.*/

/*

/* Date: 07/15/2015 Time: 10:28:44

SQLSTATE:(00000) Native Err:(3621) stmt(16578408):*/

*/

/*

/* Date: 07/15/2015 Time: 10:28:44

SQLSTATE:(00000) Native Err:(3621) status(54):*/

SWSTATUS DUMP*/

 

/* Date: 07/15/2015 Time: 10:28:44

stmt(16618184):*/

{CALL DYNAMICS.dbo.zDP_ASITAB20L_1(0,8,-32768,0,8,32767)}

 

/* Date: 07/15/2015 Time: 10:28:44

stmt(16578408):*/

BEGIN DECLARE @num int EXEC DYNAMICS.dbo.zDP_ASITAB20SI 0, 8, 345, 131, 1157, 'Action Cancelled By', 'Collections Action Cancelled By', '', 0, 1, 5, '', 0, 0, 0, '', '', 'CN_Notes', @num OUT SELECT @num END

/*

/* Date: 07/15/2015 Time: 10:28:44

SQLSTATE:(23000) Native Err:(2601) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert duplicate key row in object 'dbo.ASITAB20' with unique index 'AK2ASITAB20'. The duplicate key value is (0, 8, 1157, 131).*/

/*

/* Date: 07/15/2015 Time: 10:28:44

SQLSTATE:(01000) Native Err:(3621) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.*/

/*

/* Date: 07/15/2015 Time: 10:28:44

SQLSTATE:(00000) Native Err:(3621) stmt(16578408):*/

*/

/*

/* Date: 07/15/2015 Time: 10:28:44

SQLSTATE:(00000) Native Err:(3621) status(54):*/

SWSTATUS DUMP*/

 

/* Date: 07/15/2015 Time: 10:28:44

stmt(16618184):*/

{CALL DYNAMICS.dbo.zDP_ASITAB20L_1(0,8,-32768,0,8,32767)}

 

/* Date: 07/15/2015 Time: 10:28:44

stmt(16578408):*/

BEGIN DECLARE @num int EXEC DYNAMICS.dbo.zDP_ASITAB20SI 0, 8, 345, 132, 1157, 'Action Cancelled Date', 'Collections Action Cancelled Date', '', 0, 1, 3, '', 0, 0, 0, '', '', 'CN_Notes', @num OUT SELECT @num END

/*

/* Date: 07/15/2015 Time: 10:28:44

SQLSTATE:(23000) Native Err:(2601) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert duplicate key row in object 'dbo.ASITAB20' with unique index 'AK2ASITAB20'. The duplicate key value is (0, 8, 1157, 132).*/

/*

/* Date: 07/15/2015 Time: 10:28:44

SQLSTATE:(01000) Native Err:(3621) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.*/

/*

/* Date: 07/15/2015 Time: 10:28:44

SQLSTATE:(00000) Native Err:(3621) stmt(16578408):*/

*/

/*

/* Date: 07/15/2015 Time: 10:28:44

SQLSTATE:(00000) Native Err:(3621) status(54):*/

SWSTATUS DUMP*/

 

/* Date: 07/15/2015 Time: 10:28:44

stmt(16693264):*/

{CALL DYNAMICS.dbo.zDP_ASIEXP60L_1(0,6,-32768,0,6,32767)}

 

/* Date: 07/15/2015 Time: 10:28:44

stmt(16578408):*/

BEGIN DECLARE @num int EXEC DYNAMICS.dbo.zDP_ASIEXP60SI 0, 6, 15, 'Collection Main', 37934584, 0, @num OUT SELECT @num END

/*

/* Date: 07/15/2015 Time: 10:28:44

SQLSTATE:(23000) Native Err:(2601) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert duplicate key row in object 'dbo.ASIEXP60' with unique index 'AK2ASIEXP60'. The duplicate key value is (0, 6, 37934584).*/

/*

/* Date: 07/15/2015 Time: 10:28:44

SQLSTATE:(01000) Native Err:(3621) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.*/

/*

/* Date: 07/15/2015 Time: 10:28:44

SQLSTATE:(00000) Native Err:(3621) stmt(16578408):*/

*/

/*

/* Date: 07/15/2015 Time: 10:28:44

SQLSTATE:(00000) Native Err:(3621) status(54):*/

SWSTATUS DUMP*/

 

/* Date: 07/15/2015 Time: 10:28:44

stmt(16693264):*/

{CALL DYNAMICS.dbo.zDP_ASIEXP60L_1(0,6,-32768,0,6,32767)}

 

/* Date: 07/15/2015 Time: 10:28:44

stmt(16578408):*/

BEGIN DECLARE @num int EXEC DYNAMICS.dbo.zDP_ASIEXP60SI 0, 6, 15, 'New Collection Note', 37934591, 0, @num OUT SELECT @num END

/*

/* Date: 07/15/2015 Time: 10:28:44

SQLSTATE:(23000) Native Err:(2601) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert duplicate key row in object 'dbo.ASIEXP60' with unique index 'AK2ASIEXP60'. The duplicate key value is (0, 6, 37934591).*/

/*

/* Date: 07/15/2015 Time: 10:28:44

SQLSTATE:(01000) Native Err:(3621) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.*/

/*

/* Date: 07/15/2015 Time: 10:28:44

SQLSTATE:(00000) Native Err:(3621) stmt(16578408):*/

*/

/*

/* Date: 07/15/2015 Time: 10:28:44

SQLSTATE:(00000) Native Err:(3621) status(54):*/

SWSTATUS DUMP*/

 

/* Date: 07/15/2015 Time: 10:28:44

stmt(16693264):*/

{CALL DYNAMICS.dbo.zDP_ASIEXP60L_1(0,6,-32768,0,6,32767)}

 

/* Date: 07/15/2015 Time: 10:28:44

stmt(16578408):*/

BEGIN DECLARE @num int EXEC DYNAMICS.dbo.zDP_ASIEXP60SI 0, 6, 15, 'View Collection Note', 37935573, 0, @num OUT SELECT @num END

/*

/* Date: 07/15/2015 Time: 10:28:44

SQLSTATE:(23000) Native Err:(2601) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert duplicate key row in object 'dbo.ASIEXP60' with unique index 'AK2ASIEXP60'. The duplicate key value is (0, 6, 37935573).*/

/*

/* Date: 07/15/2015 Time: 10:28:44

SQLSTATE:(01000) Native Err:(3621) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.*/

/*

/* Date: 07/15/2015 Time: 10:28:44

SQLSTATE:(00000) Native Err:(3621) stmt(16578408):*/

*/

/*

/* Date: 07/15/2015 Time: 10:28:44

SQLSTATE:(00000) Native Err:(3621) status(54):*/

SWSTATUS DUMP*/

 

/* Date: 07/15/2015 Time: 10:28:44

stmt(16693264):*/

{CALL DYNAMICS.dbo.zDP_ASIEXP60L_1(0,8,-32768,0,8,32767)}

 

/* Date: 07/15/2015 Time: 10:28:44

stmt(16578408):*/

BEGIN DECLARE @num int EXEC DYNAMICS.dbo.zDP_ASIEXP60SI 0, 8, 12, 'Collection Main', 37934584, 0, @num OUT SELECT @num END

/*

/* Date: 07/15/2015 Time: 10:28:44

SQLSTATE:(23000) Native Err:(2601) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert duplicate key row in object 'dbo.ASIEXP60' with unique index 'AK2ASIEXP60'. The duplicate key value is (0, 8, 37934584).*/

/*

/* Date: 07/15/2015 Time: 10:28:44

SQLSTATE:(01000) Native Err:(3621) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.*/

/*

/* Date: 07/15/2015 Time: 10:28:44

SQLSTATE:(00000) Native Err:(3621) stmt(16578408):*/

*/

/*

/* Date: 07/15/2015 Time: 10:28:44

SQLSTATE:(00000) Native Err:(3621) status(54):*/

SWSTATUS DUMP*/

 

/* Date: 07/15/2015 Time: 10:28:44

stmt(16693264):*/

{CALL DYNAMICS.dbo.zDP_ASIEXP60L_1(0,8,-32768,0,8,32767)}

 

/* Date: 07/15/2015 Time: 10:28:44

stmt(16578408):*/

BEGIN DECLARE @num int EXEC DYNAMICS.dbo.zDP_ASIEXP60SI 0, 8, 12, 'New Collection Note', 37934591, 0, @num OUT SELECT @num END

/*

/* Date: 07/15/2015 Time: 10:28:44

SQLSTATE:(23000) Native Err:(2601) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert duplicate key row in object 'dbo.ASIEXP60' with unique index 'AK2ASIEXP60'. The duplicate key value is (0, 8, 37934591).*/

/*

/* Date: 07/15/2015 Time: 10:28:44

SQLSTATE:(01000) Native Err:(3621) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.*/

/*

/* Date: 07/15/2015 Time: 10:28:44

SQLSTATE:(00000) Native Err:(3621) stmt(16578408):*/

*/

/*

/* Date: 07/15/2015 Time: 10:28:44

SQLSTATE:(00000) Native Err:(3621) status(54):*/

SWSTATUS DUMP*/

 

/* Date: 07/15/2015 Time: 10:28:44

stmt(16693264):*/

{CALL DYNAMICS.dbo.zDP_ASIEXP60L_1(0,8,-32768,0,8,32767)}

 

/* Date: 07/15/2015 Time: 10:28:44

stmt(16578408):*/

BEGIN DECLARE @num int EXEC DYNAMICS.dbo.zDP_ASIEXP60SI 0, 8, 12, 'View Collection Note', 37935573, 0, @num OUT SELECT @num END

/*

/* Date: 07/15/2015 Time: 10:28:44

SQLSTATE:(23000) Native Err:(2601) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert duplicate key row in object 'dbo.ASIEXP60' with unique index 'AK2ASIEXP60'. The duplicate key value is (0, 8, 37935573).*/

/*

/* Date: 07/15/2015 Time: 10:28:44

SQLSTATE:(01000) Native Err:(3621) stmt(16578408):*/

[Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.*/

/*

/* Date: 07/15/2015 Time: 10:28:44

SQLSTATE:(00000) Native Err:(3621) stmt(16578408):*/

*/

/*

/* Date: 07/15/2015 Time: 10:28:44

SQLSTATE:(00000) Native Err:(3621) status(54):*/

SWSTATUS DUMP*/

/*

*This post is locked for comments

  • Suggested answer
    coquisalsa Profile Picture
    coquisalsa 2,725 on at
    RE: Collections Management – “Cannot insert duplicate key row in object 'dbo.ASITAB20' with unique index 'AK2ASITAB20'” error message in support debugging log when opening SmartList.

    Try using the 'SQL Maintenance' window and tick 'Create Auto Procedure'

    Microsoft Dynamics > Maintenance

    SQL.jpg

    This action will recreate SQL auto procedures related to table ASITAB20SI including zDP_ASITAB20SI

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Collections Management – “Cannot insert duplicate key row in object 'dbo.ASITAB20' with unique index 'AK2ASITAB20'” error message in support debugging log when opening SmartList.

    I deleted the records from the ASITAB20 table to avoid the duplicates error. However, once SmartLists is opened again, the records are re-inserted into the table and the error messages return the next time SmartLists is opened. I am starting to wonder if the Collections code intentionally tries to add them every time SmartLists is opened and there messages can be ignored.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Collections Management – “Cannot insert duplicate key row in object 'dbo.ASITAB20' with unique index 'AK2ASITAB20'” error message in support debugging log when opening SmartList.

    The script "SELECT * FROM ASIEXP81 WHERE ASI_Favorite_Name = 'Collections Management Notes'" does not return any records either.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Collections Management – “Cannot insert duplicate key row in object 'dbo.ASITAB20' with unique index 'AK2ASITAB20'” error message in support debugging log when opening SmartList.

    The script "SELECT * FROM SLB10000 WHERE PRODID = 1157" does not return any records.

  • coquisalsa Profile Picture
    coquisalsa 2,725 on at
    RE: Collections Management – “Cannot insert duplicate key row in object 'dbo.ASITAB20' with unique index 'AK2ASITAB20'” error message in support debugging log when opening SmartList.

    And this script too :

    USE DYNAMICS

    SELECT * FROM ASIEXP81 WHERE ASI_Favorite_Name = 'Collections Management Notes'

  • coquisalsa Profile Picture
    coquisalsa 2,725 on at
    RE: Collections Management – “Cannot insert duplicate key row in object 'dbo.ASITAB20' with unique index 'AK2ASITAB20'” error message in support debugging log when opening SmartList.

    For what you are saying, it seems you have a Collections Management SmartList created with SmartListBuilder, please run this script:

    USE DYNAMICS

    SELECT * FROM SLB10000 WHERE PRODID = 1157

    The above script will help you to identify the SmartList ID of the duplicate

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Collections Management – “Cannot insert duplicate key row in object 'dbo.ASITAB20' with unique index 'AK2ASITAB20'” error message in support debugging log when opening SmartList.

    Type above - I meant to say "I am wondering if the record with ASI_Favorite_Dict_ID = 0 might be causing the problem." Perhaps, this is a remnant from when collections was part of GP and should have been deleted as part of the upgrade.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Collections Management – “Cannot insert duplicate key row in object 'dbo.ASITAB20' with unique index 'AK2ASITAB20'” error message in support debugging log when opening SmartList.

    The SQL does not return any records. SmartList does open.  However, we are having performance issues related to SmartList. I noticed the errors when trouble shooting that issue. Not sure if the two are related yet, but I would like to eliminate the errors. I have discovered two things. One, we seem to have two Collection smartlists identical except for in name. One is called "Collection Management Notes" and the other is "Collections Management Notes". In our test environment, I am going to try to delete one of these from the ASIEXP81 table. Second, when I look for records in the ASITAB20 table with ASI_Field_Number_Dict_ID = 1157 (the id for Collections), I get rows with ASI_Favorite_Dict_ID = 0 and ASI_Favorite_Dict_ID = 1157. I am wondering if the records with ASI_Favorite_Dict_ID might be causing the problem. I am also going to try to deleting these in the test environment to see if clearing these records out resolves the problem. I will post the results once I have the opportunity to try this.

  • coquisalsa Profile Picture
    coquisalsa 2,725 on at
    RE: Collections Management – “Cannot insert duplicate key row in object 'dbo.ASITAB20' with unique index 'AK2ASITAB20'” error message in support debugging log when opening SmartList.

    Do you have access to SQL?

    Can you run this SQL and post the results?

    USE DYNAMICS

    SELECT *

    FROM  ASITAB20

    WHERE (ASI_Favorite_Dict_ID = 0) AND (ASI_Favorite_Type = 8) AND (ASI_Field_Number_Dict_ID = 1157) AND (ASI_Field_Sequence = 345)

    Does the SmartList open after you get the error?

    Can you post a screenshot of the Collections Management SmartList with its Favotites?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Collections Management – “Cannot insert duplicate key row in object 'dbo.ASITAB20' with unique index 'AK2ASITAB20'” error message in support debugging log when opening SmartList.

    Some more information. I noticed today that there are two smartlist for collections which are identical except for slightly different names. I would like to delete these smartlists altogether in our test environment to see if that resolves the issue. However, I am not sure how to do the deletion. These were not created with SmartList Builder.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,240 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans