/build/static/layout/Breadcrumb_cap_w.png

SELECT command denied to user 'R1'@'localhost' after updating K1000 to 5.4.70402

Getting an error on report PC by ship date.


SQL error shows us this:  mysql error: [1142: SELECT command denied to user 'R1'@'localhost' for table 'DELL_ASSET'] in EXECUTE("SELECT M.NAME AS MACHINE_NAME, M.CS_MODEL AS MODEL, DA.SERVICE_TAG, DA.SHIP_DATE,M.USER_LOGGED AS LAST_LOGGED_IN_USER FROM KBSYS.DELL_ASSET DA LEFT JOIN MACHINE M ON (M.BIOS_SERIAL_NUMBER = DA.PARENT_SERVICE_TAG OR M.BIOS_SERIAL_NUMBER = DA.SERVICE_TAG) WHERE M.CS_MANUFACTURER LIKE '%dell%' AND M.BIOS_SERIAL_NUMBER!='' AND DA.DISABLED != 1 ORDER BY DA.SHIP_DATE") 

Verified R1 and password is default.  Any ideas on how to correct? 

Thanks,
Geoff 


0 Comments   [ + ] Show comments

Answers (1)

Answer Summary:
Posted by: geofft 11 years ago
Senior White Belt
2

Got it figured out...simply removed the KBSYS.  from KBSYS.DELL_ASSET worked


Comments:
  • I ran in to the same issue today, and your solution worked for me. Thanks! - InaJeep 11 years ago
  • Ran into the same issue today and came across your post. It worked like a charm and the issue resolved in no time. Thanks. - nitikasinghgaba 9 years ago

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ