Database Driver Error 30 11 Peoplesoft
Technology and Trends Enterprise Architecture and EAI ERP Hardware IT Management and Strategy Java Knowledge Management Linux Networking Oracle PeopleSoft Project and Portfolio Management SAP SCM Security Siebel Storage UNIX Visual Basic Web Design and Development Windows < Back CHOOSE A DISCUSSION GROUP Research Directory TOPICS Database Hardware Networking SAP Security Web Design MEMBERS Paul_Pedant DACREE MarkDeVries Inside-ERP MacProTX VoIP_News Inside-CRM PCMag I_am_the_dragon maxwellarnold Michael Meyers-Jouan TerryCurran Chris_Day Andrew.S.Baker JoeTorre bracke Locutus Ramnath.Awate Richard DukeGanote Craig Borysowich Dennis Stevenson Nikki Klein mircea_luca AbhaiTripathi knowscognosdoi Clinton Jones bluesguyAZ59 Iqbalyk blrvenkat COMPANIES Juniper Networks CloudLock Avaya Adaptive Planning View All Topics View All Members View All Companies Toolbox for IT Topics PeopleSoft Groups Ask a New Question PeopleTools A forum where peers share technical expertise, solve problems, and discuss issues related to PeopleTools. Home | Invite Peers | More PeopleSoft Groups Your account is ready. You're now being signed in. Solve problems - It's Free Create your account in seconds E-mail address is taken If this is your account,sign in here Email address Username Between 5 and 30 characters. No spaces please The Profile Name is already in use Password Notify me of new activity in this group: Real Time Daily Never Keep me informed of the latest: White Papers Newsletter Jobs By clicking "Join Now", you agree to Toolbox for Technology terms of use, and have read and understand our privacy policy. PS/Query returns an error message : Database Drive Error (30,11) Rama Krishna PVSS asked Feb 27, 2008 | Replies (6) Hi Guys,, PS/Query returns an error message : Database Drive Error (30,11) the detail is as follows:- SQL error. Stmt #: 5682 Error Position: 0 Return: 8601 - [Microsoft][SQL Native Client]Numeric value out of range [Microsoft][SQL Native Client]Numeric value out of range (SQLSTATE 22003) 0 A SQL error occurred. Please consult your system log for details. Database Driver Error. (30,11) can
Technology and Trends Enterprise Architecture and EAI ERP Hardware IT Management and Strategy Java Knowledge Management Linux Networking Oracle PeopleSoft Project and Portfolio Management SAP SCM Security Siebel Storage UNIX Visual Basic Web Design and Development Windows < Back CHOOSE A DISCUSSION GROUP Research Directory TOPICS Database Hardware Networking SAP Security Web Design MEMBERS Paul_Pedant DACREE MarkDeVries Inside-ERP MacProTX VoIP_News Inside-CRM PCMag I_am_the_dragon maxwellarnold Michael Meyers-Jouan TerryCurran Chris_Day http://peoplesoft.ittoolbox.com/groups/technical-functional/peopletools-l/psquery-returns-an-error-message-database-drive-error-3011-1928577 Andrew.S.Baker JoeTorre bracke Locutus Ramnath.Awate Richard DukeGanote Craig Borysowich Dennis Stevenson Nikki Klein mircea_luca AbhaiTripathi knowscognosdoi Clinton Jones bluesguyAZ59 Iqbalyk blrvenkat COMPANIES Juniper Networks CloudLock Avaya Adaptive Planning View All Topics View All Members View All Companies Toolbox for IT Topics PeopleSoft Groups Ask a New Question PeopleTools A forum where peers share http://peoplesoft.ittoolbox.com/groups/technical-functional/peopletools-l/database-driver-error-3011-5262590 technical expertise, solve problems, and discuss issues related to PeopleTools. Home | Invite Peers | More PeopleSoft Groups Your account is ready. You're now being signed in. Solve problems - It's Free Create your account in seconds E-mail address is taken If this is your account,sign in here Email address Username Between 5 and 30 characters. No spaces please The Profile Name is already in use Password Notify me of new activity in this group: Real Time Daily Never Keep me informed of the latest: White Papers Newsletter Jobs By clicking "Join Now", you agree to Toolbox for Technology terms of use, and have read and understand our privacy policy. Database Driver Error (30,11) cy cu asked Jul 22, 2013 | Replies (1) I have created a query using PS Query, the above error displayed: Database Driver Error. (30,11) Unexpected exception in CApiObjectAdapterObjRef::DoMethod for Query.RunToRowset (-1,-1) I run the same SQL using Oracle SQL Deve
getting Database Driver Error (30, 11)on a subset of data. I ran this query through PeopleSoft Query (psched) to see the true error. The error message wasLeft of decimal digits http://www.psoftdev.com/2011/03/left-of-decimal-digits-truncated-from.html truncated from FETCHed value (SQLSTATE PS150). Basically this error is stating a http://www.psoftdev.com/2011_03_01_archive.html value is being returned that does notfit with the format of the reporting field. The user had a 2 decimal field and thecalculation being returned was a 6 decimal value. So the fix was to increase the number of decimal places for the calculating expression. Posted by Richard No comments: Post database driver a Comment Newer Post Older Post Home Subscribe to: Post Comments (Atom) Blog Archive ► 2016 (17) ► October (1) ► September (6) ► August (6) ► July (4) ► 2013 (7) ► June (2) ► March (1) ► February (4) ► 2012 (79) ► December (1) ► September (3) ► August (4) ► July (7) ► June (11) ► May (8) ► April database driver error (31) ► March (6) ► February (7) ► January (1) ▼ 2011 (32) ► December (3) ► November (2) ► October (1) ► September (2) ► August (2) ► July (3) ► June (1) ► May (2) ▼ March (6) How to Make a Private PeopleSoft Query Public Via ... Per Diem Update Effective April 1, 2011 Google Web Fonts Career Related Reading: Luke 3:14 Update to Zone and Job site Left of decimal digits truncated from FETCHed valu... ► February (3) ► January (7) ► 2010 (89) ► December (2) ► November (1) ► October (3) ► September (4) ► August (6) ► July (6) ► June (4) ► May (8) ► April (8) ► March (18) ► February (20) ► January (9) Labels & %UserId 1099 Update for 2010 2-bay 216) 360p at fullscreen 4-bay 480i 480p fullscreen 6 ft combo A/V cable active antenna Adesso 2.4 GHz RF AMD Athlon XP 1600 AMD Athlon XP-M Processor 2200+ ampersand and Email Notifications Antenna Antenna Web Antennas Direct DB4 Application Designer Application Engine application package Approval Workflow Engine AR_DEPOSIT_EXCEL_ADD ATI MOBILITY RADEON attic installation Audio and Video p
population of the OPRID field on the following tables: PSQRYDEFN PSQRYSELECT PSQRYRECORD PSQRYFIELD So, simply update each field using the query name criteria: UPDATE PSQRYDEFN SET OPRID = '' WHERE QRYNAME = 'YOUR_QUERY'; UPDATE PSQRYSELECT SET OPRID = '' WHERE QRYNAME = 'YOUR_QUERY'; UPDATE PSQRYRECORD SET OPRID = '' WHERE QRYNAME = 'YOUR_QUERY'; UPDATE PSQRYFIELD SET OPRID = '' WHERE QRYNAME = 'YOUR_QUERY'; Posted by Richard 2 comments: Tuesday, March 22, 2011 Per Diem Update Effective April 1, 2011 I just received notification from GSA (US General Services Administration) of a small Per Diem update effective April 1st, 2011 for the following State and City Locations: CA - Barstow / Ontario / Victorville CA - San Francisco MS - Oxford NY - Manhattan (includes the boroughs of Manhattan, Brooklyn, the Bronx, Queens and Staten Island) PA - Harrisburg / Hershey TX - Greenville VA - Bowling Green VA - Fredericksburg/Bowling Green Please go to the GSA Websiteand retrieve the Excel spreadsheet "FY 2011 Per Diem Rates (Revised)" at the right of the page under column "Downloadable Resources". All updates are highlighted in yellow within the spreadsheet. The URL ishttp://www.gsa.gov/perdiem. On a side note, there are not that many...so I would recommend normal data entry rather than the delivered interface. Posted by Richard No comments: Sunday, March 20, 2011 Google Web Fonts Ok...here is something I stumbled upon that you may have already been aware. But I think its pretty dang cool. It is Google web fonts. You simplygo tohttp://www.google.com/webfontsthen click the font you wish to use click use this font link copy the tag and paste into your CSS object call the font via CSS I do not have an example of using this on a page via PeopleSoft Application Designer. I hope to have one for you in the future. Posted by Richard No comments: Wednesday, March 16, 2011 Career Related Reading: