Installation and Technical Issues

[section203]

I have a test box w/ XP version2002 sp3, SQL 2005, and IE 8 that I have loaded web reports on to test out the web reporting functionality.  I realize this should be a server box, but it is what I have available at the moment.

I followed the installation steps including changing the IE settings, making it a trusted site,  and configuration and am able to get the web page login, login using my account and select the appropriate company.  The listing of reports come up but when I try to run the report (double-clicking) I receive the following:

Web Reports VBScript:  Task Load WebReportsEngine.TaskLoad:  Could not invoke task 50929482

2 additional points:

1 - when I go to the configuration page, I only have SQL server name and application database but the instructions show a system db field should be filled in.  My configuration page does not have it. 

2 - Once logged in to the web reports, the company drop down box has the company listed 3 times?  There is only 1 company setup in the database.

I found the following article on the kb and did what it said, but still receive the same error:

WebReportsEngine.TaskLoad: Could not invoke task..."  when launching a web report

Entry Type: Informational

Product: Sage MAS 500 ERP

Application: Web Reports

Version Reported: 6.30

Subject:
"WebReportsEngine.TaskLoad: Could not invoke task ########"  when launching a web report

Possible Resolution:
This issue is generally caused by improper installation of Web Reports.

For proper Set up of Web Reports, follow the directions for configuring DCOM in the Web Reports user guide.

1. Run DCOMCNFG.EXE from Start / Run.
2. Select the Default Properties tab.  In the Default Authentication field, select None.  In the Default Impersonation Level field, select Impersonate.

Uninstall/Reinstall Web Reports:

1. Configure the server following the instructions in the Web Reports Users Guide.
2. Uninstall Web Reports.
3. Reboot.
4. Reinstall Web Reports.
5. Reboot.
6. Navigate the browser to the Web Reports Configuration web page and enter the Server, System database, and Application database.
7. Login to Web Reports and everything should now work.

Any help would be appreciated,

Stephen

[section203 · Accepted solution]

This problem has been resolved.  there were 2 issues:

1 - select CompanyID, a.UserGroupID, Rights from tsmUserCompanyGrp a, tsmTaskPerm where a.UserID = 'IWAM_SAGECLIENT' and a.CompanyID = 'MAK' and tsmTaskPerm.UserGroupID = a.UserGroupID and TaskID = 844792 Select * from tsmUserCompanyGrp where UserID = 'IWAM_SAGECLIENT' Added the'IWAM-SAGECLIENT' user and got further along but with another message:

2 - "The page cannot be displayed" HTTP 500.100 - Internal Server Error - ASP error IIS. Went ahead and registered the asp.net and relaunched and was able to launch reports and problem solved.

Stephen