Re: patcotaskhistory error in sm.log (221 Views)
Reply
Trusted Contributor
ALARMus
Posts: 985
Registered: ‎10-06-2009
Message 1 of 7 (235 Views)
Accepted Solution

patcotaskhistory error in sm.log

  3692(  4300) 10/15/2011 12:16:34  RAD I Could not remove record. Record deleted since last retrieved
  3692(  4300) 10/15/2011 12:16:34  RTE I sqoci8: Length (68 bytes) of data for field event in patcotaskhistory exceeds max (60 bytes), truncated
  3692(  4300) 10/15/2011 12:16:34  RTE E Length (68 bytes) of data for field event in patcotaskhistory exceeds max (60 bytes), truncated (patco.rt.post.result,add)
  3692(  4300) 10/15/2011 12:16:34  RTE I sqoci8: Length (68 bytes) of data for field event in patcotaskhistory exceeds max (60 bytes), truncated
  3692(  4300) 10/15/2011 12:16:34  RTE E Length (68 bytes) of data for field event in patcotaskhistory exceeds max (60 bytes), truncated (patco.rt.post.result,add)
  3692(  4300) 10/15/2011 12:16:34  RTE I sqoci8: Length (68 bytes) of data for field event in patcotaskhistory exceeds max (60 bytes), truncated
  3692(  4300) 10/15/2011 12:16:34  RTE E Length (68 bytes) of data for field event in patcotaskhistory exceeds max (60 bytes), truncated (patco.rt.post.result,add)

Please use plain text.
Honored Contributor
Vadim Gorda
Posts: 5,632
Registered: ‎11-10-2008
Message 2 of 7 (230 Views)

Re: patcotaskhistory error in sm.log

Hello Alarmus,

As you can see from message in the patcotaskhistory table field event is only 60 bytes and something is trying to push there 68.

Go to dbdict look for table patcotaskhistory and double click on the event field. Chnage the length from 60 to 128 for example and click on ok.

Please use plain text.
Trusted Contributor
ALARMus
Posts: 985
Registered: ‎10-06-2009
Message 3 of 7 (227 Views)

Re: patcotaskhistory error in sm.log

Hello, Vadim.
this solution is obviously.
But i need to see what is this field contain.
Please use plain text.
Honored Contributor
Vadim Gorda
Posts: 5,632
Registered: ‎11-10-2008
Message 4 of 7 (223 Views)

Re: patcotaskhistory error in sm.log

If you use something like 7.x version then it will be quite easy.

Expand  the System definition in the menu  and expand tables too.

Scroll down to the table which is posted here and expand it.

In old versions there was available Data in it. In later versions HP removed it from there.

So if you have old version then you can expand Data and in any record which will be there see what is in the event field.

 

Btw it can be also done by connecting to the later version systems with for example 7.01 windows client.

 

Second way (if you can not check what is there from menu) is to look for this table from db (print db in command line and then search for that table).  System will offer you 2 forms for viewing. Before getting information which you need, you will have to add new field on the form patcotaskhistroydetail with input event. After you do that you can view what is recorded in the event field.

Please use plain text.
Trusted Contributor
ALARMus
Posts: 985
Registered: ‎10-06-2009
Message 5 of 7 (221 Views)

Re: patcotaskhistory error in sm.log

Thank you, Vadim.
I did use third method :) - look into Data Base (at Oracle server), as i see that automatically generated text by system in event field.
Please use plain text.
Honored Contributor
Vadim Gorda
Posts: 5,632
Registered: ‎11-10-2008
Message 6 of 7 (217 Views)

Re: patcotaskhistory error in sm.log

:) Suppose that was easiest way for you to do that :))))

Please use plain text.
Trusted Contributor
ALARMus
Posts: 985
Registered: ‎10-06-2009
Message 7 of 7 (214 Views)

Re: patcotaskhistory error in sm.log

[ Edited ]

yes it was.
i think it easiest way (having the smallest number of actions\steps to get result) for enybody :)
(except for those who have already displayed on the form this field)

Please use plain text.
The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation