Forum Sponsor:

Viewer for .xer, xml and xls schedule files Schedule Reader™Free Trial

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

Error Code DSEIS-2129-2

6 replies [Last post]
Sanjeet Teri
User offline. Last seen 2 weeks 6 days ago. Offline
Joined: 10 May 2005
Posts: 20

I am not able to delete any WBS and Error Code DSEIS-2129-2 appears.

Kindly help to resolve this.

Replies

Zoltan Palffy
User offline. Last seen 13 hours 2 sec ago. Offline
Joined: 13 Jul 2009
Posts: 2452
Groups: None

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

Raymund de Laza
User offline. Last seen 1 day 2 hours ago. Offline
Joined: 22 Nov 2009
Posts: 716

If you don't have the rights to delete the WBS, just Hide it.

Sanjeet Teri
User offline. Last seen 2 weeks 6 days ago. Offline
Joined: 10 May 2005
Posts: 20

I can delete Activity & Resource.

Event code comes up while deleting WBS.

 

I need solutin for this Event code DSEIS-2129-2

Sanjeet Teri
User offline. Last seen 2 weeks 6 days ago. Offline
Joined: 10 May 2005
Posts: 20

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?

Zoltan Palffy
User offline. Last seen 13 hours 2 sec ago. Offline
Joined: 13 Jul 2009
Posts: 2452
Groups: None

make sure that you have the rights to do this 

Santosh Bhat
User offline. Last seen 3 hours 15 min ago. Offline
Joined: 15 Apr 2005
Posts: 221

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