Error in Information Map Studio while testing

[deleted_user]

Hi Guys

I get this error when I try to test the information through Information Map Studio.

Exception occurred while attempting to access data.

com.sas.iquery.dataretrieval.DataRetrievalException: Exception occurred while attempting to access data. [ com.sas.iquery.dataretrieval.DataRetrievalException: Exception occurred when retrieving the ResultSet. [ com.sas.iquery.dataretrieval.DataRetrievalException: Unable to execute query. [ com.sas.iquery.execution2.ExecutionException: /* =================================== */
NOTE: Copyright (c) 2002-2003 by SAS Institute Inc., Cary, NC, USA.
NOTE: SAS (r) 9.1 (TS1M3)
Licensed to The BSS Group plc, Site 0098682001.
NOTE: This session is executing on the AIX 5.3 platform.



NOTE: SAS 9.1.3 Service Pack 4

You are running SAS 9. Some SAS 8 files will be automatically converted
by the V9 engine; others are incompatible. Please see
http://support.sas.com/rnd/migration/planning/platform/64bit.html

PROC MIGRATE will preserve current SAS file attributes and is
recommended for converting all your SAS libraries from any
SAS 8 release to SAS 9. For details and examples, please see
http://support.sas.com/rnd/migration/index.html


This message is contained in the SAS news file, and is presented upon
initialization. Edit the file "news" in the "misc/base" directory to
display site-specific news and information in the program log.
The command line option "-nonews" will prevent this display.




NOTE: SAS Initialization used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds

1 options Locale=en_GB;
1 The SAS System 13:51 Wednesday, June 20, 2007

2 LIBNAME DEVX ORACLE PATH=DEVX SCHEMA=DEVE ;
ERROR: ORACLE connection error: ORA-01017: invalid username/password; logon denied.
ERROR: Error in the LIBNAME statement.
3
2 The SAS System 13:51 Wednesday, June 20, 2007

4 Proc SQL;
4 ! Create Table A7 as
5 SELECT
6 table0.SH_SO_ACCOUNT AS DIR_2 LABEL='Sh_So_Account' FORMAT=$8.
7 FROM
8 DEVX.SH_02_SALES table0
9 ;
ERROR: Libname DEVX is not assigned.
NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements.
10 quit;
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE SQL used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds

11


Exception occurred while executing query. (select * from A7)
Unable to execute query: com.sas.iom.SASIOMDefs.GenericError: SQL passthru expression contained these errors: ERROR: File WORK.A7.DATA does not exist.... [ java.sql.SQLException: Unable to execute query: com.sas.iom.SASIOMDefs.GenericError: SQL passthru expression contained these errors: ERROR: File WORK.A7.DATA does not exist.... [ java.sql.SQLException: com.sas.iom.SASIOMDefs.GenericError: SQL passthru expression contained these errors: ERROR: File WORK.A7.DATA does not exist.... ] ] ] ] ]
at com.sas.iquery.dataretrieval.SimpleQueryConnector.retrieveQueryResultMap(Unknown Source)
at com.sas.iquery.dataretrieval.SimpleQueryConnector.retrieveQueryResultMap(Unknown Source)
at com.sas.storage.iquery.BusinessQueryAdapter.init(BusinessQueryAdapter.java:178)
at com.sas.storage.iquery.BusinessQueryToTableModelAdapter.getColumnCount(BusinessQueryToTableModelAdapter.java:344)

Error occurred generating result set

java.lang.IllegalStateException: Error occurred generating result set
at com.sas.storage.iquery.BusinessQueryAdapter.init(BusinessQueryAdapter.java:201)
at com.sas.storage.iquery.BusinessQueryToTableModelAdapter.getColumnCount(BusinessQueryToTableModelAdapter.java:344)
at javax.swing.JTable.createDefaultColumnsFromModel(JTable.java:936)
at com.sas.swing.visuals.tableview.TableView.tableChanged(TableView.java:4903)
at javax.swing.JTable.setModel(JTable.java:2721)
at com.sas.apps.mapStudio.visuals.testQuery.Test.makeTableWidget(Test.java:279)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at com.sas.apps.mapStudio.visuals.util.ProgressThread$TaskThread.run(ProgressThread.java:286)

[Cynthia_sas]

Hi:
One of your problems is listed here:

2 LIBNAME DEVX ORACLE PATH=DEVX SCHEMA=DEVE ;
ERROR: ORACLE connection error: ORA-01017: invalid username/password; logon denied.
ERROR: Error in the LIBNAME statement

with the invalid username message.

However, this is really not an Enterprise Guide question and is best answered by Tech Support.

cynthia