Hi,
months ago we created a pipeline object with a source (SAny 11) and a destination (SAny 16).
Now we change the destination db from SAny 16 to PostgreSQL 10.
As we now added a column to the pipeline object and saved the p. object, it converted all timestamp columns to uuid in the destination. (Refresh_pipeline.png)
When I now starts the pipeline object in the painter, it causes following error:
SQLSTATE = S1000 Could not convert parameter ctype to sqltype.
If I use 'Refresh' method in the pipeline object, I'll get this error permanently .
If I use 'Create' method in the pipeline object, PB converts the SAny timestamp into timestamptz in PostgreSQL and I didnt get the error while piping tables. (create_pipeline.png)
But we have to use refresh method.
Anyone who got the same problem or a solution for this?
btw, I can change this, when I 'edit source', but this couln't be the answer! But when I do this and change something in the pipeline, it will reset the timestamp to uuid!
Yes, I saw it .. thanks!
If you could attach your current pipeline source and its related SA & PG "Create Table" DML ... that would be awesome in order to help Appeon reproduce the issue.
Regards .... Chris