AnsweredAssumed Answered

error running command pdm_publish

Question asked by Marco Antonio Velazquez Aldama on Sep 18, 2016
Latest reply on Sep 21, 2016 by Marco Antonio Velazquez Aldama
 Hi  I am working with CA SDM 12.7, and we need to create new custom fields "z", we have done the following steps:  start "WSP" go Schema Designer create table "z" add columanas of "sym" type and length string 2500 add column "del" SREL to boolean active save changes click save and publish CA SDM services down run CMD console as administrator run "pdm_status" command to validate stopped services execute command "pdm_publish"  but in the execution, it shows me the following error. +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
C:\Windows\system32>pdm_status
The Daemons are not running.

C:\Windows\system32>pdm_publish
Pdm_publish - Implement DBMS schema changes from Web Screen Painter
Verifying files output from Web Screen Painter...
Verifying CA Service Desk Manager server is not running...

Merging schema files...
Schema merge successful

Building data dictionary...
Data dictionary build successful

Creating new tables...
Creating table zPosSol...

ERROR 15 [Microsoft OLE DB Provider for SQL Server] [ SQL Code=1919 SQL State=4
2000] Column 'sym' in table 'dbo.zPosSol' is of a type that is invalid for use a
s a key column in an index.

ERROR 15 [Microsoft OLE DB Provider for SQL Server] [ SQL Code=1919 SQL State=4
2000] Column 'sym' in table 'dbo.zPosSol' is of a type that is invalid for use a
s a key column in an index.
Can't spawn "cmd.exe": Bad file descriptor at .\pdm_publish.pl line 255, <ALTERT
BL> line 9.
AHD04748:sqlbuild failed for table zPosSol
Creating table zTypeAffect...

ERROR 15 [Microsoft OLE DB Provider for SQL Server] [ SQL Code=1919 SQL State=4
2000] Column 'sym' in table 'dbo.zTypeAffect' is of a type that is invalid for u
se as a key column in an index.

ERROR 15 [Microsoft OLE DB Provider for SQL Server] [ SQL Code=1919 SQL State=4
2000] Column 'sym' in table 'dbo.zTypeAffect' is of a type that is invalid for u
se as a key column in an index.
Can't spawn "cmd.exe": Bad file descriptor at .\pdm_publish.pl line 255, <ALTERT
BL> line 16.
AHD04748:sqlbuild failed for table zTypeAffect
Creating table zTypeClient...

ERROR 15 [Microsoft OLE DB Provider for SQL Server] [ SQL Code=1919 SQL State=4
2000] Column 'sym' in table 'dbo.zTypeClient' is of a type that is invalid for u
se as a key column in an index.

ERROR 15 [Microsoft OLE DB Provider for SQL Server] [ SQL Code=1919 SQL State=4
2000] Column 'sym' in table 'dbo.zTypeClient' is of a type that is invalid for u
se as a key column in an index.
Can't spawn "cmd.exe": Bad file descriptor at .\pdm_publish.pl line 255, <ALTERT
BL> line 17.
AHD04748:sqlbuild failed for table zTypeClient
Creating table zTypeEn...

ERROR 15 [Microsoft OLE DB Provider for SQL Server] [ SQL Code=1919 SQL State=4
2000] Column 'sym' in table 'dbo.zTypeEn' is of a type that is invalid for use a
s a key column in an index.

ERROR 15 [Microsoft OLE DB Provider for SQL Server] [ SQL Code=1919 SQL State=4
2000] Column 'sym' in table 'dbo.zTypeEn' is of a type that is invalid for use a
s a key column in an index.
Can't spawn "cmd.exe": Bad file descriptor at .\pdm_publish.pl line 255, <ALTERT
BL> line 18.
AHD04748:sqlbuild failed for table zTypeEn
0 table(s) added successfully; 4 errors

Rebuilding indexes for site-defined tables...
Rebuilding indexes for table zApp...
Rebuilding indexes for table zCausaRaiz...
Rebuilding indexes for table zEncuesta...
Rebuilding indexes for table zEncuesta1...
Rebuilding indexes for table zEquipo...
Rebuilding indexes for table zImputable...
Rebuilding indexes for table zLienadeNegocio...
Rebuilding indexes for table zNodos...
Rebuilding indexes for table zPosSol...

ERROR 15 [Microsoft OLE DB Provider for SQL Server] [ SQL Code=1919 SQL State=4
2000] Column 'sym' in table 'dbo.zPosSol' is of a type that is invalid for use a
s a key column in an index.

ERROR 15 [Microsoft OLE DB Provider for SQL Server] [ SQL Code=1919 SQL State=4
2000] Column 'sym' in table 'dbo.zPosSol' is of a type that is invalid for use a
s a key column in an index.
Can't spawn "cmd.exe": Bad file descriptor at .\pdm_publish.pl line 350, <INDEXS
CH> line 41.
AHD04748:sqlbuild failed for table zPosSol
Rebuilding indexes for table zProblemRC...
Rebuilding indexes for table zRegionU...
Rebuilding indexes for table zResMethod...
Rebuilding indexes for table zRptMthd...
Rebuilding indexes for table zSubtenantNX...
Rebuilding indexes for table zSupTur...
Rebuilding indexes for table zTypeAffect...

ERROR 15 [Microsoft OLE DB Provider for SQL Server] [ SQL Code=1919 SQL State=4
2000] Column 'sym' in table 'dbo.zTypeAffect' is of a type that is invalid for u
se as a key column in an index.

ERROR 15 [Microsoft OLE DB Provider for SQL Server] [ SQL Code=1919 SQL State=4
2000] Column 'sym' in table 'dbo.zTypeAffect' is of a type that is invalid for u
se as a key column in an index.
Can't spawn "cmd.exe": Bad file descriptor at .\pdm_publish.pl line 350, <INDEXS
CH> line 71.
AHD04748:sqlbuild failed for table zTypeAffect
Rebuilding indexes for table zTypeClient...

ERROR 15 [Microsoft OLE DB Provider for SQL Server] [ SQL Code=1919 SQL State=4
2000] Column 'sym' in table 'dbo.zTypeClient' is of a type that is invalid for u
se as a key column in an index.

ERROR 15 [Microsoft OLE DB Provider for SQL Server] [ SQL Code=1919 SQL State=4
2000] Column 'sym' in table 'dbo.zTypeClient' is of a type that is invalid for u
se as a key column in an index.
Can't spawn "cmd.exe": Bad file descriptor at .\pdm_publish.pl line 350, <INDEXS
CH> line 76.
AHD04748:sqlbuild failed for table zTypeClient
Rebuilding indexes for table zTypeEn...

ERROR 15 [Microsoft OLE DB Provider for SQL Server] [ SQL Code=1919 SQL State=4
2000] Column 'sym' in table 'dbo.zTypeEn' is of a type that is invalid for use a
s a key column in an index.

ERROR 15 [Microsoft OLE DB Provider for SQL Server] [ SQL Code=1919 SQL State=4
2000] Column 'sym' in table 'dbo.zTypeEn' is of a type that is invalid for use a
s a key column in an index.
Can't spawn "cmd.exe": Bad file descriptor at .\pdm_publish.pl line 350, <INDEXS
CH> line 81.
AHD04748:sqlbuild failed for table zTypeEn
Rebuilding indexes for table zViaAtencion...
Rebuilding indexes for table zWorkspaceRC...
Rebuilding indexes for table zWorkspaceSolution...
Rebuilding indexes for table zequiporep...
Rebuilding indexes for table zfactura...
Rebuilding indexes for table zimpacto...
Rebuilding indexes for table zpcatCF...
Rebuilding indexes for table zrootCF...
Rebuilding indexes for table zrootNW...
Rebuilding indexes for table zrootchg...
Rebuilding indexes for table zsolutionCF...
Rebuilding indexes for table ztiporep...
Rebuilding indexes for table ztipotkt...
Rebuilding indexes for table zvip...
AHD04791:Succesfully rebuilt indexes for 28 tables; 4 errors

Building data dictionary...
Data dictionary build successful


Building tblobj.cfg file...
Build tblobj.cfg file successful

Normal end of pdm_publish; 8 error(s) encountered

C:\Windows\System32>


+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
I could help resolve the error, as this is a production environment and is very important to us.   Regards, Marco Velazquez.

Outcomes