I am not able to delete any WBS and Error Code DSEIS-2129-2 appears.
Kindly help to resolve this.
Error Code DSEIS-2129-2
Forum Sponsor
Top Posters
Julian Pegg
1 posts
Peter Nagy
2 posts
Raymund de Laza
17 posts
Syed_Asad
0 posts
Tony Greyvenstein
0 posts
Ahmed Al-Jubouri
13 posts
Umar Alvi
3 posts
Sibusiso Mahlalela
0 posts
Michael Samanyayi
3 posts
Simon Gumede
0 posts
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
If you don't have the rights to delete the WBS, just Hide it.
I can delete Activity & Resource.
Event code comes up while deleting WBS.
I need solutin for this Event code DSEIS-2129-2
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?
make sure that you have the rights to do this
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