Respected Sir/ Madam,
We are working with PB19 R2 build 2323 and facing fields assignments being disturbed issues. Following is detailed information about the issue.
1. open created pipeline in pipeline painter and we can see fields assignments gets disturbed i.e. one source field is assigned to incorrect one. Please refer attached screen with red highlighted section.
2. We can see correct assignment in edit source of the pipeline.
3. I would like to further inform that both source and destination connections of pipeline are up and working condition.
4. The functionality is extremely business critical and so we need to work in edit source of the pipeline which is awkward and confusing.
Requesting to provide solution of issue asap so that we can work smoothly with pipeline.
Thank you.
Best Regards,
Romesh
Below is my database connection parameters. Please note that this connection is created in db profile and I am opening pipeline in pipeline painter.
SQLCA.DBMS = "SNC SQL Native Client(OLE DB)"
SQLCA.ServerName = "db1"
SQLCA.LogId = "user1"
SQLCA.AutoCommit = False
SQLCA.DBParm = "TrustedConnection=1,Provider='SQLNCLI11',Database='db1'"
I could not find the option "MSOLEDBSQL SQL Server" in db param so could not assign this in sqlca.dbms,
Thank you.
Best Regards,
Romesh
"MSOLEDBSQL SQL Server" is one of the newly added interfaces in PB 2019 R3, thus please upgrade to PB 2019 R3 Build 2703 and then try again.
Regards,
Ken