Highlighted
Anonymous_User Absent Member.
Absent Member.
399 views

HOW TO DEBUG DB COLLECTOR - DATE FORMAT PROBLEM


Hi All,

i created a oracle collector. i have a query like below;

select
MY_DATE,
TO_CHAR('MY_DATE','YYYY/MM/DD HH24:MI:SS','nls_date_language=AMERICAN')
MDATE

WHERE
MY_DATE >= TO_DATE('%s','YYYY/MM/DD
HH24:MI:SS','nls_date_language=AMERICAN') and rownum <= %d

ORDER BY
MY_DATE

and i am returning 'return input.RXMap.col_MDATE;'

When i run the collector it is giving to me ORA-01840 input value not
long enough for date format so i want to debug and see the value of %s.

When run the collector debug mod always saying to me NODATA. Anybody
know how can debug and how can see %s value ??


--
ibasaran
------------------------------------------------------------------------
ibasaran's Profile: https://forums.netiq.com/member.php?userid=2826
View this thread: https://forums.netiq.com/showthread.php?t=46067

0 Likes
2 Replies
Anonymous_User Absent Member.
Absent Member.

Re: HOW TO DEBUG DB COLLECTOR - DATE FORMAT PROBLEM

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

You may have better luck in the plugin SDK forum for developers as this
is about customizing something with the SDK.

Good luck.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.19 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://www.enigmail.net/

iQIcBAEBAgAGBQJQk9iZAAoJEF+XTK08PnB5oz0P/i5CJfpEbCY22oEpg2VSowek
IHbP2MCA+/hwA8R0KVOvYtld7o9G083VuXxsHUREbEEE+6Eb+Fw0P8Xp4HX29lM0
Xh5Lwi/yu3fvPIyPI0UpOHOoLYUqjVjhKh/dWHjCBSVzSt+hgIgqRJQR4uIkCswy
eDQzPYb3h9naqmnyN4oetvwrnvrhLbH9WNcDOHW81Z1g9MHnekUicXxaZuA/85Hm
87tp/ST44AJXq0uYj9+BKc3WMyaH6f7ZB1CXu5IqJUJXxeSxaekKJvEPk/lgBSX7
Tc8tK3jygu/sB4coYG8r0IRgWinIiu3c1Xrhm9K0V1DS0FgwMhhoKEon403/Im67
CpFIgyQNnl04qEOKWuuaAZVQXOi4GdzrvQs60QcOCPjeJ9M7Lysc/KUd3/tx4jW/
RiDvLtNmXb/TZWWRrMIdkixn/vGFL61Lh0N6q4fsYqiQroUCm7k4nzjre90fCKys
ar288T2Etzbjc0atu1jccKHv0EjBEDvt+fdbXLNPSMhSY0pFMOX5OZMsmJVhOdjh
SklIVRcROY+7AxUnFVohL+j8NWiZSSIOn7UtWbBPq6AOA6pmYa0GULHSRkhgbDtf
jjzYOqnFA0QiayXzTtuqgMTCQJO2WI44nvBbgqDX38/vvxiFgZXDh4CN19GB9iKq
gskof5OT5zVCqaBW8adp
=JDks
-----END PGP SIGNATURE-----
0 Likes
Anonymous_User Absent Member.
Absent Member.

Re: HOW TO DEBUG DB COLLECTOR - DATE FORMAT PROBLEM


thnks ab i created new one to plugin SDK forum


--
ibasaran
------------------------------------------------------------------------
ibasaran's Profile: https://forums.netiq.com/member.php?userid=2826
View this thread: https://forums.netiq.com/showthread.php?t=46067

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.