The P6 application runs queries that use non-ANSI outer join operators ("*=" or "=*"). To be able to run these queries, SQL Server database compatibility level should be set to 80. However, this is not supported in SQL Server 2012 and later versions, causing this issue to occur. The SQL Server version installed is not supported to work with your P6 version.
Solutions
Solution 1
1) Backup your P6 database
2) Export all your data to P6 files. (Projects to XER, Layouts to PLF)
3) Uninstall unsupported SQL Server version
4) Install a supported SQL Server version
5) Create a P6 database and configure the alias
6) Import the files back into P6 database
Solution 2
Upgrade your database and P6 application to a version where SQL Server 2012 is supported
Member for
15 years 11 months
Member for15 years11 months
Submitted by Raymund de Laza on Sun, 2019-10-20 10:12
This is from Oracle support - acces to Oracle support is part of your maintenance:
Error: "PRMDB-3932-D" Or PRM DBAccess Error: Database Server Error: Incorrect syntax near "*" When Deleting a Resource, WBS or Activity on P6 Desktop Client (Doc ID 1565159.1)
Symptoms
When attempting to delete a WBS, Activity or Resource P6 crashes with the following error:
Event Code: PRMDB-3932-D
Description: PRM DBAccess Error: Database Server Error: Incorrect syntax near "*".
Event Code: DSEIS-2129-2
Description: PRM DBAccess Error: Database Server Error: Incorrect syntax near "*".
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Member for
16 years 3 monthsThe cause: The P6 application
The cause:
The P6 application runs queries that use non-ANSI outer join operators ("*=" or "=*"). To be able to run these queries, SQL Server database compatibility level should be set to 80. However, this is not supported in SQL Server 2012 and later versions, causing this issue to occur. The SQL Server version installed is not supported to work with your P6 version.
Solutions
Solution 1
1) Backup your P6 database
2) Export all your data to P6 files. (Projects to XER, Layouts to PLF)
3) Uninstall unsupported SQL Server version
4) Install a supported SQL Server version
5) Create a P6 database and configure the alias
6) Import the files back into P6 database
Solution 2
Upgrade your database and P6 application to a version where SQL Server 2012 is supported
Member for
15 years 11 monthsIf you don't have the rights
If you don't have the rights to delete the WBS, just Hide it.
Member for
20 years 5 monthsI can delete Activity &
I can delete Activity & Resource.
Event code comes up while deleting WBS.
I need solutin for this Event code DSEIS-2129-2
Member for
20 years 5 monthsI tried to delete WBS,
I tried to delete WBS, Resouce and Activity.
I am able to delete activity & Resource. The event code appears while deleting WBS.
Any solution for this?
Member for
16 years 3 monthsmake sure that you have the
make sure that you have the rights to do this
Member for
20 years 6 monthsThis is from Oracle support -
This is from Oracle support - acces to Oracle support is part of your maintenance:
Error: "PRMDB-3932-D" Or PRM DBAccess Error: Database Server Error: Incorrect syntax near "*" When Deleting a Resource, WBS or Activity on P6 Desktop Client (Doc ID 1565159.1)
Symptoms
When attempting to delete a WBS, Activity or Resource P6 crashes with the following error:
Event Code: PRMDB-3932-D
Description: PRM DBAccess Error: Database Server Error: Incorrect syntax near "*".
Event Code: DSEIS-2129-2
Description: PRM DBAccess Error: Database Server Error: Incorrect syntax near "*".
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Log into P6
2. Attempt to delete WBS, Resource or Activity