PROC_CREATE_IDX_DUPCHK end with error due inexistent tablespace
Hi,
During semahore.reg processing, the procedure PROC_CREATE_IDX_DUPCHK is called to upload the new bufferLimit and StoreLimit dates but due the name of the index and tablespace being the same, the procedure fails with error 'Procedure: 'PROC_CREATE_IDX_DUPCHK' execute failed, 'Vendor Error: 959'.'
In order to debug the error we try to put the input values on table and conclude that the name of the index and tablespace are the same.
During the creation of the tables IFW_DUPLICATECHECK the tablespace name used was other a default one ('PIN00').
So the error have to do with this tablespace name that came from pipeline.