*** withdefault has joined #ingres | 00:01 | |
*** ChanServ sets mode: +o withdefault | 00:01 | |
*** Gerhard has joined #ingres | 00:08 | |
*** Gerhard has quit IRC | 00:59 | |
*** Gerhard has joined #ingres | 01:48 | |
Gerhard | Hi all | 01:48 |
---|---|---|
*** grantc has joined #ingres | 01:53 | |
*** ChanServ sets mode: +o grantc | 01:53 | |
Gerhard | It seems to me that on Windows machines up-to-date Ingres patch installers are worse than those in the Ingres 2.5/2.6 era. Any opinions about this? | 02:00 |
Gerhard | example: on two machines with Ingres 9.2.0, p13354 failed because %II_SYSTEM%\ingres\bin\cazipxp.exe was newer than the file included in the patch, so patch installer told me... | 02:07 |
Gerhard | ...it was "interrupted" (very bad error error message). Looking at patch.log unveiled the problem so I manipulated the time stamp of the file to make it look 2 years older and after that, I could apply the patch. | 02:08 |
*** [1]Gerhard has joined #ingres | 02:29 | |
*** Gerhard has quit IRC | 02:33 | |
*** [1]Gerhard is now known as Gerhard | 02:33 | |
*** toumi01 has joined #ingres | 04:27 | |
*** skythe has quit IRC | 04:38 | |
*** skythe has joined #ingres | 04:39 | |
*** skythe has quit IRC | 05:29 | |
*** skythe has joined #ingres | 05:29 | |
*** skythe has quit IRC | 05:31 | |
*** skythe has joined #ingres | 05:34 | |
*** DarylM has joined #ingres | 06:00 | |
*** Gerhard has quit IRC | 06:11 | |
thiagomz | Guys... if I got a Duplicated Keys, generated by a Rule... how to known what table is causing that ? the message do not show me nothing to help me. | 06:22 |
thiagomz | :-9 | 06:22 |
thiagomz | :-( | 06:22 |
*** DarylM has quit IRC | 06:38 | |
toumi01 | thiagomz: IIRC there was a community forum thread about your duplicate key and rule problem a few months ago. It did not yield a solution? | 06:51 |
thiagomz | toumi01: tkz.. i will look for it... | 06:52 |
toumi01 | Was it you who initiated the thread? | 06:53 |
thiagomz | yes, was me.. | 06:56 |
thiagomz | my developers is using print rules | 06:56 |
thiagomz | so, they identify the last rule | 06:57 |
thiagomz | and debug it to identify what was the table | 06:57 |
toumi01 | but that isn't doing the job for them? | 06:57 |
thiagomz | yeah, but they spend a lot of time to identify a single table... | 06:58 |
thiagomz | ingres should show ta table name on the message... | 06:58 |
toumi01 | Karl (kschendel) in the thread indicates it's a hard problem - and he is probably the world expert in terms of knowing both Ingres internals and hands-on situations. | 06:59 |
toumi01 | Probably the reason that the table does not get named in the message - this is a guess - is because of the layering of Ingres facilities. This compartmentalizes function (a good coding technique) but also compartmentalizes info that would help in messages (bad). | 07:00 |
toumi01 | The solutions could be (1) a code change to figure out how to get the name of the table into the message or (2) a strategy better than you have thus far found to infer the info from other traces and logs etc. | 07:01 |
thiagomz | set trace point sc924 4500; | 07:02 |
thiagomz | commit; | 07:02 |
thiagomz | i will try it... | 07:02 |
toumi01 | Have you tried the comp.databases.ingres news group to see if there are clever ideas out there? | 07:02 |
toumi01 | It is now integrated with the community forum: http://community.ingres.com/forum/comp-databases-ingres/ | 07:03 |
toumi01 | There are some old hands with Ingres who use c.d.i but not the community forums. | 07:03 |
thiagomz | toumi01: tkz | 07:05 |
*** mull has joined #ingres | 07:17 | |
thiagomz | toumi01: other problem... | 07:20 |
thiagomz | on my procedure i have a insert... after that my developer check if the insert ran with sucess.... | 07:21 |
thiagomz | on 4Gl , if i got the duplicated key... | 07:22 |
thiagomz | it show me my custom message... sample : " Error trying to insert on XXX table ..." | 07:22 |
thiagomz | in 4GL Vision it is ok... | 07:22 |
thiagomz | but.. here we use Ingres ODBC with POWER Builder... | 07:23 |
thiagomz | on it.. i see only the Duplicated key error... | 07:23 |
thiagomz | i cant see my custom message... | 07:23 |
thiagomz | any idea ? | 07:23 |
toumi01 | not sure I understand the exact mechanisms here... | 07:24 |
thiagomz | imagine... | 07:25 |
thiagomz | a procedure with a INSERT ... | 07:25 |
toumi01 | the 4GL messages about XXX table was for table being updated that triggered the problem or actual duplicate error because of a rule? | 07:25 |
thiagomz | after the insert... I check if the insert ran... was executed... | 07:25 |
thiagomz | with sucess | 07:25 |
thiagomz | if not OK show message " error inserting on table X module RH " .... | 07:26 |
thiagomz | on 4GL i saw my custom message... | 07:26 |
toumi01 | the rule provides the custom message? | 07:26 |
thiagomz | but not in my ODBC Ingres with PowerBuilder | 07:26 |
toumi01 | and with 4GL you see it? | 07:27 |
thiagomz | yeah.. | 07:27 |
toumi01 | but with ODBC you can't get the message back to the user interface? | 07:27 |
thiagomz | i wil put it on pastebin... one moment | 07:27 |
thiagomz | toumi01: perfect | 07:27 |
thiagomz | my english is not so bad ... | 07:27 |
thiagomz | ;) | 07:27 |
toumi01 | not bad at all :) | 07:28 |
toumi01 | very quiet here on #ingres today ... ODBC folks on summer holiday? ;) | 07:28 |
grantc | eh ? ;) | 07:29 |
thiagomz | http://pastebin.com/m3d1b174a | 07:29 |
toumi01 | :) | 07:29 |
thiagomz | the code goes after the insert on the procedure | 07:30 |
toumi01 | so the issue is how to make this message caused by <> 0 return status visible to the end user with your current tool set? or maybe to trap it and handle it in the program? | 07:32 |
*** DarylM has joined #ingres | 07:32 | |
thiagomz | toumi01: yes | 07:32 |
thiagomz | toumi01: that code works on Vision | 07:33 |
thiagomz | but no to ODBC with Powerbuilder | 07:33 |
thiagomz | but not | 07:33 |
thiagomz | my ingres is 2.6 | 07:34 |
toumi01 | I'm no ODBC expert. Anyone else here know? Have you tried http://community.ingres.com/forum/database-drivers-apis/ and/or c.d.i for this issue? | 07:35 |
thiagomz | we can change the question... | 07:38 |
thiagomz | How to treat error codes on procedures ? | 07:38 |
toumi01 | exactly | 07:38 |
thiagomz | how to obtain it and manipulate it... | 07:38 |
toumi01 | but I'm not sure of the answer | 07:39 |
thiagomz | ;) | 07:39 |
thiagomz | i will put it on forum | 07:39 |
thiagomz | http://community.ingres.com/forum/dba-forum/10877-how-treat-error-codes-procedures.html#post26476 | 07:43 |
grantc | SQLError() is the function you call to fetch the error | 07:43 |
thiagomz | toumi01: look if you can understand. | 07:43 |
thiagomz | grantc: do you have a example ? | 07:44 |
grantc | at least at the C layer - I guess powerbuilder has something that maps | 07:44 |
grantc | http://ingres.pastebin.com/m58e5feec | 07:45 |
thiagomz | i was talking to my developer... | 07:49 |
thiagomz | and he said that... | 07:50 |
thiagomz | if i run a procedure on isql | 07:50 |
thiagomz | and it generate a error... | 07:50 |
thiagomz | the procedure stops ... after the error ... | 07:50 |
thiagomz | and do not show the custom message... | 07:51 |
*** DarylM has quit IRC | 07:52 | |
grantc | i cannot remember if terminal monitor shows messages returned from a procedure | 07:53 |
*** grantc has quit IRC | 07:57 | |
*** atrofast has joined #ingres | 08:04 | |
*** atrofast has quit IRC | 08:11 | |
*** atrofast has joined #ingres | 08:12 | |
*** DerMeister has joined #ingres | 08:46 | |
*** Deyan has joined #ingres | 09:12 | |
Deyan | hello guys | 09:12 |
Deyan | anyone around? :) | 09:12 |
*** grantc has joined #ingres | 09:22 | |
*** ChanServ sets mode: +o grantc | 09:22 | |
*** Deyan has quit IRC | 09:33 | |
*** grantc_ has joined #ingres | 10:25 | |
*** ChanServ sets mode: +o grantc_ | 10:25 | |
*** grantc has quit IRC | 10:26 | |
*** grantc_ has quit IRC | 10:40 | |
*** skythe has quit IRC | 12:26 | |
*** skythe has joined #ingres | 12:27 | |
*** withdefault has left #ingres | 12:40 | |
*** rossand has joined #ingres | 12:55 | |
*** ChanServ sets mode: +o rossand | 12:55 | |
*** mull has quit IRC | 13:02 | |
*** thiagomz has quit IRC | 13:03 | |
*** rossand has quit IRC | 13:05 | |
*** rossand has joined #ingres | 13:06 | |
*** ChanServ sets mode: +o rossand | 13:06 | |
*** Gerhard has joined #ingres | 13:10 | |
*** mull has joined #ingres | 13:30 | |
*** skythe has quit IRC | 13:54 | |
*** Gerhard has left #ingres | 13:59 | |
*** skythe has joined #ingres | 14:01 | |
*** atrofast has quit IRC | 14:29 | |
*** DerMeister has quit IRC | 14:31 | |
*** rossand has quit IRC | 15:28 | |
*** skythe has quit IRC | 15:34 | |
*** zxiiro has joined #ingres | 15:34 | |
*** zxiiro has quit IRC | 15:35 | |
*** zxiiro has joined #ingres | 15:35 | |
*** ChanServ sets mode: +v zxiiro | 15:36 | |
*** rossand has joined #ingres | 18:06 | |
*** ChanServ sets mode: +o rossand | 18:06 | |
*** toumi01 has quit IRC | 18:33 | |
*** rossand has quit IRC | 19:03 | |
*** rossand has joined #ingres | 19:09 | |
*** ChanServ sets mode: +o rossand | 19:09 | |
*** rossand has quit IRC | 19:31 | |
*** zxiiro has quit IRC | 19:43 | |
*** zxiiro has joined #ingres | 19:48 | |
*** rossand has joined #ingres | 19:55 | |
*** ChanServ sets mode: +o rossand | 19:55 | |
*** mull has quit IRC | 20:10 | |
*** zxiiro has quit IRC | 20:22 | |
*** zxiiro has joined #ingres | 20:23 | |
*** rossand has quit IRC | 21:10 | |
*** rossand has joined #ingres | 21:15 | |
*** ChanServ sets mode: +o rossand | 21:15 | |
*** rossand has quit IRC | 21:53 | |
*** zxiiro has quit IRC | 22:17 | |
*** zxiiro has joined #ingres | 22:18 |
Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!