Unable to map secRole (m1, TEXT) to a5, varchar(50) in operator dbdict
We are trying to map field secRole (m1, TEXT) to (a5, varchar(50) in operator dbdict, but getting errors are below:
Getting the below error:
SQL State: 42000-8180 Message: [Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s) could not be prepared. (record.update,start)
SQL State: 42S21-2705 Message: [Microsoft][ODBC SQL Server Driver][SQL Server]Column names in each table must be unique. Column name 'RECORD_NUMBER' in table '
SMSQL9B70B00A36530CD' is specified more than once. (record.update,start).
While saving the change to operator dbdict, I have changed SQL RC from false to true
I forget to mention to version for HP Service Manager it is v9.41.
OOB secrole is mapped in operator dbdict as shown in below screenshot:
Now When I'm trying to map the secrole field as below :
It is throwing erros as mentioned in above post.
There is another utility apart from dbdict in HPSM, which is called - "System Definition Utility". Go to left side Navigation pane, Click on "System Definition". Search for Operator table under "Tables". And look out for the field - "Secrole". Double click to expand the field properties.
Update the alias table name from m1 to a1 and click on "Save". It will update the ddl at the backend. Now go and check the dbdict record. the field should be displaying under a1 as required.