Hi all, i have a problem deploying a database structure update to ml-clients. Sybase Central obviously puts spaces into my script at random positions...! Original task:
Deployed task:
This is really ** - i don't need to mention. Best regards, Axel |
I'm still having problems with the deployment of tasks... I must not use "<>" in SQL-Scripts because they are always disrupted into "< >" with varying count of blanks. I'm using "!=" instead. This SQL-Script throws an error when executed via agent: create or replace trigger InsCheckNextAufgTask after insert order 1 on DBA.OBJ_TO_PL referencing new as "NewRow" for each row begin if current remote user is null then call "dba"."proc_SetNextObjTaskPl"("NewRow"."obj_id","NewRow"."pl_id") end if end; The error message is "Line 4 had error: Item 'PL' already exists" If i execute the script directly on the remote database it runs through without any problem. It seems like the agent does not simply execute the "create trigger" statement but tries to run the trigger instantly oder something like that. I don't understand it. The whole system of remote tasks is not usable!!! :-( Regards, Axel As this error seems to be related to the cursor variable: Does this also occur if you use a FOR statement instead (which would also be much easier and shorter IMHO)? Can't comment on the basic question, as I never have used the ML Agent..
(14 Mar '18, 09:49)
Volker Barth
The agent has to run the "creater trigger"-statement, not to declare the cursor, Volker...
(14 Mar '18, 11:07)
Axel Siepmann
Replies hidden
Yes, I'm aware of that... It's just a wild guess to debug that error...
(14 Mar '18, 11:33)
Volker Barth
I think that's a fundamental error with the agent. It just has to passthrough the statements to the client and that does not work.
(14 Mar '18, 13:03)
Axel Siepmann
|
May i hope for a solution or even an answer? |
Unfortunately this problem still exists in SA 17.10.5866 I'm still not able to deploy a structure update with Sybase Central. After creating the original task everthing is ok: After deploying the task to the first agent there is a blank between then smaler sign and the bigger sign: So the whole system for distributing tasks to ML Agent is unusable. What can i do? Should i open a case? Thanks, Axel |
Is it really random? If you look at the script, would it be possible for you to check whether the spaces are being inserted every 32k or possibly at some other exponent of 2?
Nice edit comment, Reg, anyway:)
Maybe it's around pos 16384 if i delete all comments. Not sure...
Btw: It seems to happen while copying the text to the task windows in Sybase Central - not while deploying a task to agents.