If you are unable to create a new account, please email support@bspsoftware.com

 

Impromptu 7.4: new user runs reports, gets blank screen; old user can run rpt

Started by bG, 17 Nov 2011 04:33:09 PM

Previous topic - Next topic

bG

I have a curious situation with a user running Impromptu 7.4 under XP Pro in an Active Directory/Exchange domain environment.

User Alice used Impromptu, left and was replaced by Bob.  Bob gets new machine and Impromptu was installed on it with no problems.

Bob quits and Alice returns.  She gets her old AD login back.  She can login as Bob and run reports.  If she logs in as herself and runs the same report or builds a new one from scratch, Impromptu reads the data quickly and then gets no report.  She sees the gray background of the Impromtu desktop.  No report.  :o

I have tried making Alice an administrator of the PC, reinstalled Impromptu as her, tried changing the User Workspace (the last two to see if it was some exotic permission issue) without success.

Any suggestions on what could be the problem?  Or even a solution?

MFGF

Which Access Manager user classes does Alice belong to? Has her login been removed from her old user classes after she left?
Meep!

bG

Access manager is not used.  She and Bob are basically of the User class.  When Impromptu was installed on the new PC, no access restrictions was setup.


MFGF

So, if you're not using Access Manager, Alice doesn't actually log into Impromptu - she just selects a user class when she connects?

How is the data source connection defined in Impromptu, and what database is it connecting to? For example, is it trying to use an ODBC connection that Alice doesn't have access to? Is it a direct connection to SQL Server that uses the AD login to connect?

I would probably focus on these areas to begin with.

Regards,

MF.
Meep!

ianderson

When you say 'logs in as' are you referring to Impromptu (by selecting a different user class), or Windows itself?

If it's Windows, check the default printer when logged in as Alice, and make sure it's set to an actual printer rather than 'Document Writer' - i've seen problems before where the default printer is not set it doesn't show in page layout - you could also check this by switching to screen layout after the report appears to have run, and see if it has actually puled back data.

If the only difference is the user class that is picked when running Impromptu, then check the governor settings against each of the classes and make sure they are the same.

bG

Thanks for your replies.  I finally returned from my vacation/break
over Thanksgiving and I've finally caught up to--last week.

Yes, my terminology was sloppy.  Impromptu is run on the PC with a catalog
located on a network drive. 

The Data Definition Manager says the access is through the Informix ODBC driver to the database.

The user "logs in" to the ODBC connection when
accessing the catalog ("Catalog Logon for X.CAT"), user class is "User".
The alternative  user class that Alice can't use is "Creator".  Both User Classes have
no password.  Both Alice and Bob both are in the "User" class.

bG

When Alice returned to her desk today and logged into AD/the network as herself, I checked the printers.  You, ianderson, was right! She had several invalid printers setup which could not work.  I deleted them, re-added valid ones and she could run her reports!
  :(  :o  ::) :)  :D  ;D