Finance | Project Operations, Human Resources, ...

GP 18.3 Upgrade Stuck on Posting Definitions Master Table

(0) Share

Report

Posted on by john.ellis

3,510

Hi:

I'm on the last leg of the upgrade path from GP 2013 to GP 2013 R2 to GP 2016 R2 (16.00.0885) to GP 18.3.1245.

Here on GP 18.3.1245, GP Utilities seems to be "stuck" on the Posting Definitions Master table for one company, albeit the largest of the seven.

This did not happen, when I upgraded GP 2013 to GP 2013 R2 and then to GP 2016 R2.

It has been on this table for nearly 6.00 hours.

Shall I simply "ride it out"?

John

Categories:

Microsoft Dynamics GP

I have the same question (0)

All responses (23)

Answers (0)

Suggested answer

Lisa at AonC.com 937 Super User 2025 Season 2 on at

Like (0)

Report

Check the fiscal year/periods to confirm there are no overlapping fiscal years. (It seems like there was a Hot Topic for this a few versions back, possibly when Open/History inquiry windows were combined, but I'm not seeing it in GP 18.3 Hot Topic/scripts.) If you want to look via SQL, check the company's SY40101 table and work through each YEAR1 and the FSTFSCDY and LSTFSCDY to confirm they are all valid and none overlap.

Was this reply helpful? Yes No
john.ellis 3,510 on at

Like (0)

Report

Thanks, Lisa! What's the remedy, if there are any?

John

Was this reply helpful? Yes No
Suggested answer

Lisa at AonC.com 937 Super User 2025 Season 2 on at

Like (0)

Report

If you are finding overlapping, fiscal years you'll need to next determine if there are any transactions posted to the overlapping period (and which year).

If you are finding a break in fiscal years, you may just be able to expand one of the years (make sure to also check the periods) to cover the missing period. (You probably need to also check to see if there are possibly transactions posted to the missing date range.)

If you find a problem with years/periods and can wait until Monday, someone in Microsoft GP Support may be able to provide scripts to help with this analysis.

[When I have run into this in the past it was after a client had accidentally modified a previous fiscal year when attempting to create a new fiscal year. The issue was found after just a few entries were posted so the cleanup was very minor.]

Was this reply helpful? Yes No
john.ellis 3,510 on at

Like (0)

Report

Hi:

I checked the SY40101 table, and there are no overlapping fiscal years.

Is there anything else that I can check?

John

Was this reply helpful? Yes No
Lisa at AonC.com 937 Super User 2025 Season 2 on at

Like (0)

Report

I'm out for the weekend with limited access to resources. SQL trace, review DU tables for errors, restart the update, search the Hot Topics/blog posts are the generic tasks I can think of.

Hopefully Support will get you a specific solution when they are back in tomorrow as I'm pretty sure I have seen this before back a few years, possibly with GP 2015 upgrades.

Was this reply helpful? Yes No
Jagille on at

Like (1)

Report
Hi John,

I've seen an issue like this in the past and normally we have to re-create the SY00500 table. I would recommend taking a backup of where you're at in the upgrade now, then test moving the data from the SY00500 table into a backup table, re-create the SY00500 by right-clicking on it in the DYNAMICS database and selecting to "Create To New Query Window". Run that, then use the following KB article to DTS the data back into the newly created table from the backup table that was just created.

SELECT * INTO SY00500_BAK FROM SY00500.

Run the Recreate SY00500 script in a New Query Window.

Move data back using this KB article.

874208 How to transfer setup information between company databases by using Microsoft SQL Server

https://support.microsoft.com/en-US/help/874208

You might be able to perform this after the upgrade completes too, but I would test the upgrade with data first to ensure that it gets into the right columns.

Drop the backup table after transferring the data.

DROP TABLE SY00500_BAK

Kick off the upgrade and see if it goes through this time.

Another thing you can check is if there are any custom triggers in the Server Objects folder within SQL Server Management Studio.

Within SQL Server Management Studio, expand Server Objects.

Expand Triggers.

If you see anything in the ‘Triggers’ folder, right-click on them and select ‘Disable’.

Then see if the upgrade continues.

Let us know what you get for results and we’ll go from there.

Was this reply helpful? Yes No
Suggested answer

Derek Albaugh on at

Like (1)

Report

Anytime you fail on a table(s) during an upgrade, 99% of the time, we would ask for this information in order to troubleshoot:

A. From the failed state of the upgrade, run the following scripts against your DYNAMICS/system database for GP:

Delete DU000030 where Status <> 0 and Status <> 15

B. Start a dexsql.log file for Dynamics GP xxxx that you're upgrading to and delete any prior dexsql.log files that may already exist:

KB article 850996 - How to create a Dexsql.log file for Microsoft Dynamics GP and Great Plains

support.microsoft.com/.../how-to-create-a-dexsql-log-file-to-troubleshoot-error-messages-in-micr

C. Launch Dynamics GP xxxx utilities and continue the upgrade of the failing system or company database.

If the upgrade fails again on this or any other errors, we would ask to see the dexsql.log file created and then the results of the following scripts, ran against the GP system database:

1. Select CMPANYID,CMPNYNAM,INTERID from SY01500

2. Select * from DB_Upgrade

3. Select * from DU000020 order by companyID

4. SELECT b.fileOSName, a.fileNumber, a.PRODID, a.Status, a.errornum, a.errordes, c.CMPANYID, c.INTERID FROM DU000030 a JOIN DU000010 b ON a.fileNumber = b.fileNumber AND a.PRODID = b.PRODID JOIN SY01500 c ON a.companyID = c.CMPANYID WHERE (a.Status <> 0 or a.errornum <> 0) and a.Status <>15

This last script is our 'failed tables' script, which tells us which tables are failing the upgrade, and a description of why. We also start here to look through the dexsql.log for additional information.

The db_status of the DB_Upgrade table and the Status/errornum values in this 'failed tables' script also give us information as to what part of the upgrade it is failing on.

If the upgrade fails on something other than a table, the last script won't have anything in it, but the dexsql.log and error being seen in GP Utilities (both parts) is what we would use to troubleshoot.

Just FYI........

There isn't any way for us to know an upgrade is stuck/hanging/failing on a table, such as SY00500 in this case, and know why without the above information.

Any known issues we discover with tables on a specific upgrade, we'll usually blog about as well.

Thanks

Was this reply helpful? Yes No
john.ellis 3,510 on at

Like (0)

Report

Thanks, Derek!

The failed tables script came up "blank". And, I saw nothing out of the ordinary, upon running the other scripts.

But, I did see several of the following similar statements in the DEXSQL.LOG:

Cannot drop the procedure 'dbo.zDP_SY00500GP19YSS_1', because it does not exist or you do not have permission.*/

Do such statements mean anything?

John

Was this reply helpful? Yes No
Suggested answer

Derek Albaugh on at

Like (0)

Report

Without the full error, not really.

zDP_SY00500GP19YSS_1 would appear to be a custom dex procedure as I am not aware of having any by that name, as default.

Thanks

Was this reply helpful? Yes No
john.ellis 3,510 on at

Like (0)

Report

Below is an excerpt of the DEXSQL.Log:

/* Date: 04/19/2021 Time: 11:38:28

stmt(134748352):*/

SELECT COUNT(BCHSOURC) FROM CCCT1.dbo.SY00500GP19Y

/* Date: 04/19/2021 Time: 11:38:28

stmt(134742928):*/

declare @cStatement varchar(255) declare T_cursor CURSOR for select 'drop index SY00500.' + name from sysindexes where name like 'AK%SY00500' or name like 'CL%SY00500' set nocount on OPEN T_cursor FETCH NEXT FROM T_cursor INTO @cStatement WHILE (@@FETCH_STATUS <> -1) begin EXEC (@cStatement) FETCH NEXT FROM T_cursor INTO @cStatement end DEALLOCATE T_cursor

/* Date: 04/19/2021 Time: 11:38:28

stmt(134742928):*/

declare @cStatement varchar(255) declare T_cursor CURSOR for select 'alter table SY00500 drop constraint ' + name from sysindexes where name like 'PKSY00500' set nocount on OPEN T_cursor FETCH NEXT FROM T_cursor INTO @cStatement WHILE (@@FETCH_STATUS <> -1) begin EXEC (@cStatement) FETCH NEXT FROM T_cursor INTO @cStatement end DEALLOCATE T_cursor

/* Date: 04/19/2021 Time: 11:38:28

stmt(134748352):*/

ALTER TABLE CCCT1.dbo.SY00500 ADD CONSTRAINT PKSY00500 PRIMARY KEY NONCLUSTERED (BCHSOURC, BACHNUMB)

/* Date: 04/19/2021 Time: 11:38:28

stmt(134748352):*/

CREATE UNIQUE INDEX AK2SY00500 ON CCCT1.dbo.SY00500 (BACHNUMB, DEX_ROW_ID)

/* Date: 04/19/2021 Time: 11:38:28

stmt(134748352):*/

CREATE UNIQUE INDEX AK3SY00500 ON CCCT1.dbo.SY00500 (BACHFREQ, DEX_ROW_ID)

/* Date: 04/19/2021 Time: 11:38:28

stmt(134748352):*/

CREATE UNIQUE INDEX AK4SY00500 ON CCCT1.dbo.SY00500 (SERIES, BCHSOURC, DEX_ROW_ID)

/* Date: 04/19/2021 Time: 11:38:28

stmt(134748352):*/

CREATE UNIQUE INDEX AK5SY00500 ON CCCT1.dbo.SY00500 (SERIES, BACHNUMB, DEX_ROW_ID)

/* Date: 04/19/2021 Time: 11:38:28

stmt(134748352):*/

CREATE UNIQUE INDEX AK6SY00500 ON CCCT1.dbo.SY00500 (SERIES, BACHFREQ, DEX_ROW_ID)

/* Date: 04/19/2021 Time: 11:38:28

stmt(134748352):*/

CREATE UNIQUE INDEX AK7SY00500 ON CCCT1.dbo.SY00500 (SERIES, BCHSOURC, BACHNUMB)

/* Date: 04/19/2021 Time: 11:38:28

stmt(134742928):*/

GRANT SELECT, UPDATE, INSERT, DELETE ON [SY00500] TO [DYNGRP]

/* Date: 04/19/2021 Time: 11:38:28

stmt(134742928):*/

DECLARE @sqlstring CHAR(255) DECLARE p_cursor CURSOR for select 'grant execute on [' + o.name + '] to [DYNGRP]' from sysdepends d, sysobjects o where d.depid = object_id('SY00500') and d.id = o.id and o.type = 'P' set NOCOUNT on open p_cursor FETCH NEXT FROM p_cursor INTO @sqlstring while(@@fetch_status <> -1) begin if (@@fetch_status <> -2) begin exec (@sqlstring) end FETCH NEXT FROM p_cursor INTO @sqlstring end DEALLOCATE p_cursor

/* Date: 04/19/2021 Time: 11:38:33

stmt(134745640):*/

{ CALL DYNAMICS.dbo.zDP_DU000030SS_3 ( 0, 772, 6 ) }

/* Date: 04/19/2021 Time: 11:38:33

stmt(134745640):*/

{ CALL DYNAMICS.dbo.zDP_DU000030SS_3 ( 0, 772, 6 ) }

/* Date: 04/19/2021 Time: 11:38:33*/

Prepared stmt(134746544):

/*

/* Date: 04/19/2021 Time: 11:38:33

SQLSTATE:(S0022) Native Err:(207) stmt(134741120):*/

[Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid column name 'desSPRkmhBBCreh'.*/

/*

/* Date: 04/19/2021 Time: 11:38:33

SQLSTATE:(00000) Native Err:(207) stmt(134741120):*/

*/

/*

/* Date: 04/19/2021 Time: 11:38:33

SQLSTATE:(00000) Native Err:(207) status(41):*/

SWSTATUS DUMP*/

/* Date: 04/19/2021 Time: 11:38:33

stmt(134747448):*/

BEGIN TRAN SELECT count(*) FROM CCCT1.dbo.SY00500GP19Y (TABLOCKX) WHERE 1=2 ; set nocount on ;

/* Date: 04/19/2021 Time: 11:38:33

stmt(134747448):*/

COMMIT TRAN

/*

/* Date: 04/19/2021 Time: 11:38:33

SQLSTATE:(00000) Native Err:(-1) stmt(134747448):*/

*/

/*

/* Date: 04/19/2021 Time: 11:38:33

SQLSTATE:(00000) Native Err:(-1) status(0):*/

SWSTATUS DUMP*/

/* Date: 04/19/2021 Time: 11:38:33

stmt(134747448):*/

DROP PROC dbo.zDP_SY00500GP19YSS_1, dbo.zDP_SY00500GP19YN_1, dbo.zDP_SY00500GP19YF_1, dbo.zDP_SY00500GP19YL_1, dbo.zDP_SY00500GP19YSS_2, dbo.zDP_SY00500GP19YUN_2, dbo.zDP_SY00500GP19YN_2, dbo.zDP_SY00500GP19YF_2, dbo.zDP_SY00500GP19YL_2, dbo.zDP_SY00500GP19YSS_3, dbo.zDP_SY00500GP19YUN_3, dbo.zDP_SY00500GP19YN_3, dbo.zDP_SY00500GP19YF_3, dbo.zDP_SY00500GP19YL_3, dbo.zDP_SY00500GP19YSS_4, dbo.zDP_SY00500GP19YUN_4, dbo.zDP_SY00500GP19YN_4, dbo.zDP_SY00500GP19YF_4, dbo.zDP_SY00500GP19YL_4, dbo.zDP_SY00500GP19YSS_5, dbo.zDP_SY00500GP19YUN_5, dbo.zDP_SY00500GP19YN_5, dbo.zDP_SY00500GP19YF_5, dbo.zDP_SY00500GP19YL_5, dbo.zDP_SY00500GP19YSS_6, dbo.zDP_SY00500GP19YUN_6, dbo.zDP_SY00500GP19YN_6, dbo.zDP_SY00500GP19YF_6, dbo.zDP_SY00500GP19YL_6, dbo.zDP_SY00500GP19YSS_7, dbo.zDP_SY00500GP19YN_7, dbo.zDP_SY00500GP19YF_7, dbo.zDP_SY00500GP19YL_7, dbo.zDP_SY00500GP19YSI, dbo.zDP_SY00500GP19YSD

/*

/* Date: 04/19/2021 Time: 11:38:33

SQLSTATE:(S0002) Native Err:(3701) stmt(134747448):*/

[Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot drop the procedure 'dbo.zDP_SY00500GP19YSS_1', because it does not exist or you do not have permission.*/

/*

/* Date: 04/19/2021 Time: 11:38:33

SQLSTATE:(S0002) Native Err:(3701) stmt(134747448):*/

[Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot drop the procedure 'dbo.zDP_SY00500GP19YN_1', because it does not exist or you do not have permission.*/

/*

/* Date: 04/19/2021 Time: 11:38:33

SQLSTATE:(S0002) Native Err:(3701) stmt(134747448):*/

[Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot drop the procedure 'dbo.zDP_SY00500GP19YF_1', because it does not exist or you do not have permission.*/

/*

/* Date: 04/19/2021 Time: 11:38:33

SQLSTATE:(S0002) Native Err:(3701) stmt(134747448):*/

[Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot drop the procedure 'dbo.zDP_SY00500GP19YL_1', because it does not exist or you do not have permission.*/

/*

/* Date: 04/19/2021 Time: 11:38:33

SQLSTATE:(S0002) Native Err:(3701) stmt(134747448):*/

[Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot drop the procedure 'dbo.zDP_SY00500GP19YSS_2', because it does not exist or you do not have permission.*/

/*

/* Date: 04/19/2021 Time: 11:38:33

SQLSTATE:(S0002) Native Err:(3701) stmt(134747448):*/

[Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot drop the procedure 'dbo.zDP_SY00500GP19YUN_2', because it does not exist or you do not have permission.*/

/*

/* Date: 04/19/2021 Time: 11:38:33

SQLSTATE:(S0002) Native Err:(3701) stmt(134747448):*/

[Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot drop the procedure 'dbo.zDP_SY00500GP19YN_2', because it does not exist or you do not have permission.*/

/*

/* Date: 04/19/2021 Time: 11:38:33

SQLSTATE:(S0002) Native Err:(3701) stmt(134747448):*/

[Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot drop the procedure 'dbo.zDP_SY00500GP19YF_2', because it does not exist or you do not have permission.*/

/*

/* Date: 04/19/2021 Time: 11:38:33

SQLSTATE:(S0002) Native Err:(3701) stmt(134747448):*/

[Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot drop the procedure 'dbo.zDP_SY00500GP19YL_2', because it does not exist or you do not have permission.*/

/*

/* Date: 04/19/2021 Time: 11:38:33

SQLSTATE:(S0002) Native Err:(3701) stmt(134747448):*/

[Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot drop the procedure 'dbo.zDP_SY00500GP19YSS_3', because it does not exist or you do not have permission.*/

/*

/* Date: 04/19/2021 Time: 11:38:33

SQLSTATE:(S0002) Native Err:(3701) stmt(134747448):*/

[Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot drop the procedure 'dbo.zDP_SY00500GP19YUN_3', because it does not exist or you do not have permission.*/

/*

/* Date: 04/19/2021 Time: 11:38:33

SQLSTATE:(S0002) Native Err:(3701) stmt(134747448):*/

[Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot drop the procedure 'dbo.zDP_SY00500GP19YN_3', because it does not exist or you do not have permission.*/

/*

/* Date: 04/19/2021 Time: 11:38:33

SQLSTATE:(S0002) Native Err:(3701) stmt(134747448):*/

[Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot drop the procedure 'dbo.zDP_SY00500GP19YF_3', because it does not exist or you do not have permission.*/

/*

/* Date: 04/19/2021 Time: 11:38:33

SQLSTATE:(S0002) Native Err:(3701) stmt(134747448):*/

[Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot drop the procedure 'dbo.zDP_SY00500GP19YL_3', because it does not exist or you do not have permission.*/

/*

/* Date: 04/19/2021 Time: 11:38:33

SQLSTATE:(S0002) Native Err:(3701) stmt(134747448):*/

[Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot drop the procedure 'dbo.zDP_SY00500GP19YSS_4', because it does not exist or you do not have permission.*/

/*

/* Date: 04/19/2021 Time: 11:38:33

SQLSTATE:(S0002) Native Err:(3701) stmt(134747448):*/

[Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot drop the procedure 'dbo.zDP_SY00500GP19YUN_4', because it does not exist or you do not have permission.*/

/*

/* Date: 04/19/2021 Time: 11:38:33

SQLSTATE:(S0002) Native Err:(3701) stmt(134747448):*/

[Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot drop the procedure 'dbo.zDP_SY00500GP19YN_4', because it does not exist or you do not have permission.*/

/*

/* Date: 04/19/2021 Time: 11:38:33

SQLSTATE:(S0002) Native Err:(3701) stmt(134747448):*/

[Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot drop the procedure 'dbo.zDP_SY00500GP19YF_4', because it does not exist or you do not have permission.*/

/*

/* Date: 04/19/2021 Time: 11:38:33

SQLSTATE:(S0002) Native Err:(3701) stmt(134747448):*/

[Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot drop the procedure 'dbo.zDP_SY00500GP19YL_4', because it does not exist or you do not have permission.*/

/*

/* Date: 04/19/2021 Time: 11:38:33

SQLSTATE:(S0002) Native Err:(3701) stmt(134747448):*/

[Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot drop the procedure 'dbo.zDP_SY00500GP19YSS_5', because it does not exist or you do not have permission.*/

/*

/* Date: 04/19/2021 Time: 11:38:33

SQLSTATE:(S0002) Native Err:(3701) stmt(134747448):*/

[Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot drop the procedure 'dbo.zDP_SY00500GP19YUN_5', because it does not exist or you do not have permission.*/

/*

/* Date: 04/19/2021 Time: 11:38:33

SQLSTATE:(S0002) Native Err:(3701) stmt(134747448):*/

[Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot drop the procedure 'dbo.zDP_SY00500GP19YN_5', because it does not exist or you do not have permission.*/

/*

/* Date: 04/19/2021 Time: 11:38:33

SQLSTATE:(S0002) Native Err:(3701) stmt(134747448):*/

[Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot drop the procedure 'dbo.zDP_SY00500GP19YF_5', because it does not exist or you do not have permission.*/

/*

/* Date: 04/19/2021 Time: 11:38:33

SQLSTATE:(S0002) Native Err:(3701) stmt(134747448):*/

[Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot drop the procedure 'dbo.zDP_SY00500GP19YL_5', because it does not exist or you do not have permission.*/

/*

/* Date: 04/19/2021 Time: 11:38:33

SQLSTATE:(S0002) Native Err:(3701) stmt(134747448):*/

[Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot drop the procedure 'dbo.zDP_SY00500GP19YSS_6', because it does not exist or you do not have permission.*/

/*

/* Date: 04/19/2021 Time: 11:38:33

SQLSTATE:(S0002) Native Err:(3701) stmt(134747448):*/

[Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot drop the procedure 'dbo.zDP_SY00500GP19YUN_6', because it does not exist or you do not have permission.*/

/*

/* Date: 04/19/2021 Time: 11:38:33

SQLSTATE:(S0002) Native Err:(3701) stmt(134747448):*/

[Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot drop the procedure 'dbo.zDP_SY00500GP19YN_6', because it does not exist or you do not have permission.*/

/*

/* Date: 04/19/2021 Time: 11:38:33

SQLSTATE:(S0002) Native Err:(3701) stmt(134747448):*/

[Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot drop the procedure 'dbo.zDP_SY00500GP19YF_6', because it does not exist or you do not have permission.*/

/*

/* Date: 04/19/2021 Time: 11:38:33

SQLSTATE:(S0002) Native Err:(3701) stmt(134747448):*/

[Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot drop the procedure 'dbo.zDP_SY00500GP19YL_6', because it does not exist or you do not have permission.*/

/*

/* Date: 04/19/2021 Time: 11:38:33

SQLSTATE:(S0002) Native Err:(3701) stmt(134747448):*/

[Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot drop the procedure 'dbo.zDP_SY00500GP19YSS_7', because it does not exist or you do not have permission.*/

/*

/* Date: 04/19/2021 Time: 11:38:33

SQLSTATE:(S0002) Native Err:(3701) stmt(134747448):*/

[Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot drop the procedure 'dbo.zDP_SY00500GP19YN_7', because it does not exist or you do not have permission.*/

/*

/* Date: 04/19/2021 Time: 11:38:33

SQLSTATE:(S0002) Native Err:(3701) stmt(134747448):*/

[Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot drop the procedure 'dbo.zDP_SY00500GP19YF_7', because it does not exist or you do not have permission.*/

/*

/* Date: 04/19/2021 Time: 11:38:33

SQLSTATE:(S0002) Native Err:(3701) stmt(134747448):*/

[Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot drop the procedure 'dbo.zDP_SY00500GP19YL_7', because it does not exist or you do not have permission.*/

/*

/* Date: 04/19/2021 Time: 11:38:33

SQLSTATE:(S0002) Native Err:(3701) stmt(134747448):*/

[Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot drop the procedure 'dbo.zDP_SY00500GP19YSI', because it does not exist or you do not have permission.*/

/*

/* Date: 04/19/2021 Time: 11:38:33

SQLSTATE:(S0002) Native Err:(3701) stmt(134747448):*/

[Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot drop the procedure 'dbo.zDP_SY00500GP19YSD', because it does not exist or you do not have permission.*/

/*

/* Date: 04/19/2021 Time: 11:38:33

SQLSTATE:(00000) Native Err:(3701) stmt(134747448):*/

*/

/*

/* Date: 04/19/2021 Time: 11:38:33

SQLSTATE:(00000) Native Err:(3701) status(56):*/

SWSTATUS DUMP*/

/* Date: 04/19/2021 Time: 11:38:33

stmt(134747448):*/

DROP PROC dbo.zDP_SY00500GP19YSS_1, dbo.zDP_SY00500GP19YN_1, dbo.zDP_SY00500GP19YF_1, dbo.zDP_SY00500GP19YL_1, dbo.zDP_SY00500GP19YSS_2, dbo.zDP_SY00500GP19YUN_2, dbo.zDP_SY00500GP19YN_2, dbo.zDP_SY00500GP19YF_2, dbo.zDP_SY00500GP19YL_2, dbo.zDP_SY00500GP19YSS_3, dbo.zDP_SY00500GP19YUN_3, dbo.zDP_SY00500GP19YN_3, dbo.zDP_SY00500GP19YF_3, dbo.zDP_SY00500GP19YL_3, dbo.zDP_SY00500GP19YSS_4, dbo.zDP_SY00500GP19YUN_4, dbo.zDP_SY00500GP19YN_4, dbo.zDP_SY00500GP19YF_4, dbo.zDP_SY00500GP19YL_4, dbo.zDP_SY00500GP19YSS_5, dbo.zDP_SY00500GP19YUN_5, dbo.zDP_SY00500GP19YN_5, dbo.zDP_SY00500GP19YF_5, dbo.zDP_SY00500GP19YL_5, dbo.zDP_SY00500GP19YSS_6, dbo.zDP_SY00500GP19YUN_6, dbo.zDP_SY00500GP19YN_6, dbo.zDP_SY00500GP19YF_6, dbo.zDP_SY00500GP19YL_6, dbo.zDP_SY00500GP19YSS_7, dbo.zDP_SY00500GP19YN_7, dbo.zDP_SY00500GP19YF_7, dbo.zDP_SY00500GP19YL_7, dbo.zDP_SY00500GP19YSI, dbo.zDP_SY00500GP19YSD

/*

/* Date: 04/19/2021 Time: 11:38:33

SQLSTATE:(S0002) Native Err:(3701) stmt(134747448):*/

[Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot drop the procedure 'dbo.zDP_SY00500GP19YSS_1', because it does not exist or you do not have permission.*/

/*

/* Date: 04/19/2021 Time: 11:38:33

SQLSTATE:(S0002) Native Err:(3701) stmt(134747448):*/

[Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot drop the procedure 'dbo.zDP_SY00500GP19YN_1', because it does not exist or you do not have permission.*/

/*

/* Date: 04/19/2021 Time: 11:38:33

SQLSTATE:(S0002) Native Err:(3701) stmt(134747448):*/

[Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot drop the procedure 'dbo.zDP_SY00500GP19YF_1', because it does not exist or you do not have permission.*/

/*

/* Date: 04/19/2021 Time: 11:38:33

SQLSTATE:(S0002) Native Err:(3701) stmt(134747448):*/

[Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot drop the procedure 'dbo.zDP_SY00500GP19YL_1', because it does not exist or you do not have permission.*/

/*

/* Date: 04/19/2021 Time: 11:38:33

SQLSTATE:(S0002) Native Err:(3701) stmt(134747448):*/

[Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot drop the procedure 'dbo.zDP_SY00500GP19YSS_2', because it does not exist or you do not have permission.*/

/*

/* Date: 04/19/2021 Time: 11:38:33

SQLSTATE:(S0002) Native Err:(3701) stmt(134747448):*/

[Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot drop the procedure 'dbo.zDP_SY00500GP19YUN_2', because it does not exist or you do not have permission.*/

/*

/* Date: 04/19/2021 Time: 11:38:33

SQLSTATE:(S0002) Native Err:(3701) stmt(134747448):*/

[Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot drop the procedure 'dbo.zDP_SY00500GP19YN_2', because it does not exist or you do not have permission.*/

/*

/* Date: 04/19/2021 Time: 11:38:33

SQLSTATE:(S0002) Native Err:(3701) stmt(134747448):*/

[Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot drop the procedure 'dbo.zDP_SY00500GP19YF_2', because it does not exist or you do not have permission.*/

/*

/* Date: 04/19/2021 Time: 11:38:33

SQLSTATE:(S0002) Native Err:(3701) stmt(134747448):*/

[Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot drop the procedure 'dbo.zDP_SY00500GP19YL_2', because it does not exist or you do not have permission.*/

/*

/* Date: 04/19/2021 Time: 11:38:33

SQLSTATE:(S0002) Native Err:(3701) stmt(134747448):*/

[Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot drop the procedure 'dbo.zDP_SY00500GP19YSS_3', because it does not exist or you do not have permission.*/

/*

/* Date: 04/19/2021 Time: 11:38:33

SQLSTATE:(S0002) Native Err:(3701) stmt(134747448):*/

[Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot drop the procedure 'dbo.zDP_SY00500GP19YUN_3', because it does not exist or you do not have permission.*/

/*

/* Date: 04/19/2021 Time: 11:38:33

SQLSTATE:(S0002) Native Err:(3701) stmt(134747448):*/

[Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot drop the procedure 'dbo.zDP_SY00500GP19YN_3', because it does not exist or you do not have permission.*/

/*

/* Date: 04/19/2021 Time: 11:38:33

SQLSTATE:(S0002) Native Err:(3701) stmt(134747448):*/

[Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot drop the procedure 'dbo.zDP_SY00500GP19YF_3', because it does not exist or you do not have permission.*/

/*

/* Date: 04/19/2021 Time: 11:38:33

SQLSTATE:(S0002) Native Err:(3701) stmt(134747448):*/

[Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot drop the procedure 'dbo.zDP_SY00500GP19YL_3', because it does not exist or you do not have permission.*/

/*

/* Date: 04/19/2021 Time: 11:38:33

SQLSTATE:(S0002) Native Err:(3701) stmt(134747448):*/

[Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot drop the procedure 'dbo.zDP_SY00500GP19YSS_4', because it does not exist or you do not have permission.*/

/*

/* Date: 04/19/2021 Time: 11:38:33

SQLSTATE:(S0002) Native Err:(3701) stmt(134747448):*/

[Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot drop the procedure 'dbo.zDP_SY00500GP19YUN_4', because it does not exist or you do not have permission.*/

/*

/* Date: 04/19/2021 Time: 11:38:33

SQLSTATE:(S0002) Native Err:(3701) stmt(134747448):*/

[Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot drop the procedure 'dbo.zDP_SY00500GP19YN_4', because it does not exist or you do not have permission.*/

/*

/* Date: 04/19/2021 Time: 11:38:33

SQLSTATE:(S0002) Native Err:(3701) stmt(134747448):*/

[Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot drop the procedure 'dbo.zDP_SY00500GP19YF_4', because it does not exist or you do not have permission.*/

/*

/* Date: 04/19/2021 Time: 11:38:33

SQLSTATE:(S0002) Native Err:(3701) stmt(134747448):*/

[Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot drop the procedure 'dbo.zDP_SY00500GP19YL_4', because it does not exist or you do not have permission.*/

/*

/* Date: 04/19/2021 Time: 11:38:33

SQLSTATE:(S0002) Native Err:(3701) stmt(134747448):*/

[Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot drop the procedure 'dbo.zDP_SY00500GP19YSS_5', because it does not exist or you do not have permission.*/

/*

/* Date: 04/19/2021 Time: 11:38:33

SQLSTATE:(S0002) Native Err:(3701) stmt(134747448):*/

[Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot drop the procedure 'dbo.zDP_SY00500GP19YUN_5', because it does not exist or you do not have permission.*/

/*

/* Date: 04/19/2021 Time: 11:38:33

SQLSTATE:(S0002) Native Err:(3701) stmt(134747448):*/

[Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot drop the procedure 'dbo.zDP_SY00500GP19YN_5', because it does not exist or you do not have permission.*/

/*

/* Date: 04/19/2021 Time: 11:38:33

SQLSTATE:(S0002) Native Err:(3701) stmt(134747448):*/

[Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot drop the procedure 'dbo.zDP_SY00500GP19YF_5', because it does not exist or you do not have permission.*/

/*

/* Date: 04/19/2021 Time: 11:38:33

SQLSTATE:(S0002) Native Err:(3701) stmt(134747448):*/

[Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot drop the procedure 'dbo.zDP_SY00500GP19YL_5', because it does not exist or you do not have permission.*/

/*

/* Date: 04/19/2021 Time: 11:38:33

SQLSTATE:(S0002) Native Err:(3701) stmt(134747448):*/

[Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot drop the procedure 'dbo.zDP_SY00500GP19YSS_6', because it does not exist or you do not have permission.*/

/*

/* Date: 04/19/2021 Time: 11:38:33

SQLSTATE:(S0002) Native Err:(3701) stmt(134747448):*/

[Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot drop the procedure 'dbo.zDP_SY00500GP19YUN_6', because it does not exist or you do not have permission.*/

/*

/* Date: 04/19/2021 Time: 11:38:33

SQLSTATE:(S0002) Native Err:(3701) stmt(134747448):*/

[Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot drop the procedure 'dbo.zDP_SY00500GP19YN_6', because it does not exist or you do not have permission.*/

/*

/* Date: 04/19/2021 Time: 11:38:33

SQLSTATE:(S0002) Native Err:(3701) stmt(134747448):*/

[Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot drop the procedure 'dbo.zDP_SY00500GP19YF_6', because it does not exist or you do not have permission.*/

/*

/* Date: 04/19/2021 Time: 11:38:33

SQLSTATE:(S0002) Native Err:(3701) stmt(134747448):*/

[Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot drop the procedure 'dbo.zDP_SY00500GP19YL_6', because it does not exist or you do not have permission.*/

/*

/* Date: 04/19/2021 Time: 11:38:33

SQLSTATE:(S0002) Native Err:(3701) stmt(134747448):*/

[Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot drop the procedure 'dbo.zDP_SY00500GP19YSS_7', because it does not exist or you do not have permission.*/

/*

/* Date: 04/19/2021 Time: 11:38:33

SQLSTATE:(S0002) Native Err:(3701) stmt(134747448):*/

[Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot drop the procedure 'dbo.zDP_SY00500GP19YN_7', because it does not exist or you do not have permission.*/

/*

/* Date: 04/19/2021 Time: 11:38:33

SQLSTATE:(S0002) Native Err:(3701) stmt(134747448):*/

[Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot drop the procedure 'dbo.zDP_SY00500GP19YF_7', because it does not exist or you do not have permission.*/

/*

/* Date: 04/19/2021 Time: 11:38:33

SQLSTATE:(S0002) Native Err:(3701) stmt(134747448):*/

[Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot drop the procedure 'dbo.zDP_SY00500GP19YL_7', because it does not exist or you do not have permission.*/

/*

/* Date: 04/19/2021 Time: 11:38:33

SQLSTATE:(S0002) Native Err:(3701) stmt(134747448):*/

[Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot drop the procedure 'dbo.zDP_SY00500GP19YSI', because it does not exist or you do not have permission.*/

/*

/* Date: 04/19/2021 Time: 11:38:33

SQLSTATE:(S0002) Native Err:(3701) stmt(134747448):*/

[Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot drop the procedure 'dbo.zDP_SY00500GP19YSD', because it does not exist or you do not have permission.*/

/*

/* Date: 04/19/2021 Time: 11:38:33

SQLSTATE:(00000) Native Err:(3701) stmt(134747448):*/

*/

/*

/* Date: 04/19/2021 Time: 11:38:33

SQLSTATE:(00000) Native Err:(3701) status(56):*/

SWSTATUS DUMP*/

/*

/* Date: 04/19/2021 Time: 11:38:33

SQLSTATE:(00000) Native Err:(-1) stmt(134747448):*/

*/

/*

/* Date: 04/19/2021 Time: 11:38:33

SQLSTATE:(00000) Native Err:(-1) status(0):*/

SWSTATUS DUMP*/

/* Date: 04/19/2021 Time: 11:38:33

stmt(134747448):*/

DROP TABLE CCCT1.dbo.SY00500GP19Y

/* Date: 04/19/2021 Time: 11:38:33

stmt(134745640):*/

{ CALL DYNAMICS.dbo.zDP_DU000030SS_3 ( 0, 772, 6 ) }

/* Date: 04/19/2021 Time: 11:38:33

stmt(134745640):*/

{ CALL DYNAMICS.dbo.zDP_DU000030SS_3 ( 0, 772, 6 ) }

/* Date: 04/19/2021 Time: 11:38:33*/

Prepared stmt(134746544):

/* Date: 04/19/2021 Time: 11:38:33

stmt(134745640):*/

{ CALL DYNAMICS.dbo.zDP_DU000030SS_3 ( 0, 773, 6 ) }

/* Date: 04/19/2021 Time: 11:38:33

stmt(134744736):*/

{ CALL DYNAMICS.dbo.zDP_DU000010SS_1 ( 0, 773 ) }

/* Date: 04/19/2021 Time: 11:38:33

stmt(134744736):*/

{ CALL DYNAMICS.dbo.zDP_DU000010SS_1 ( 0, 773 ) }

/* Date: 04/19/2021 Time: 11:38:33

stmt(134742928):*/

UPDATE SOP10100 SET Workflow_Status = 9 UPDATE SOP10100 SET WorkflowPriorityCreditLm = 1 WHERE WorkflowPriorityCreditLm = 2 or WorkflowPriorityQuote = 2

Was this reply helpful? Yes No