Application Available: TEM Web Console

(imported topic written by Lee Wei)

Hi all,

I posted a new app call TEM Web Console in the TEM Wiki.

Please check it out.

TEM Web Console

Haha, I did not know which Forum Category to post this under…

TEM Customization

TEM Labs

TEM Web Reports and Custom Reports

Lee Wei

(imported comment written by SystemAdmin)

hi,

cool… :slight_smile:

I have my fixlets in a custom site and get this error:

Error: Singular expression refers to nonexistent object. (scroll down to see statement)

See a screenshot in the attachment.

Thanks

Andi

Greetings from Austria

(imported comment written by Lee Wei)

Andi,

Thank you for reporting the problem. I have fixed the error in version 0.81.

You can remove and install, or you can simply replace the attached file temwc.js.

It does into the the following directory, or where your IIS is installed.

C:\inetpub\wwwroot\temwc\resources\javascript

Lee Wei

(imported comment written by SystemAdmin)

hi lee wei,

i changed the file and it works now.

Another question:

For the webreports i use a own user called “itkdb” and the login works fine.

But if I want to use this user to login into the TEM Web Console, I always get following error:

The assigned role at the webreport is administrator

See attached file.

Thanks Andi

(imported comment written by SystemAdmin)

hi,

if I want to distibute a fixlet an click “take action” I get following error:

Error from the TakeAction handler in the TEMWC application: Error loading Fixlet: Database Error:

Microsoft

http://SQL Server Native Client 10.0

SQL Server

Login failed for user ‘IIS APPPOOL\DefaultAppPool’. (28000:18456)

Thanks Andi

(imported comment written by Lee Wei)

Andi,

It is not clear to me whether the username “itkdb” is successful or always fail.

In the message you had mention that this is login works fine, but the attached picture looks like it is failing.

You have been able to log into the system before, are you able to determine the difference between the 2 users?

I do not recognize the error message about SQL Server, so I will have to check into that further.

Lee Wei

(imported comment written by SystemAdmin)

hi lee wei,

before I used the bfadmin user account for webreport and console, this works.

Now I tried for webreports the user “itkdb” and for the console login the “bfadmin” and i get the error in the attachments.

If i logged into the webreports with itkdb this works also fine, see the user settings in the second picture.

Where is the problem?

Thanks Andi

(imported comment written by SystemAdmin)

hi,

if I want to distibute a fixlet an click “take action” I get following error:

Error from the TakeAction handler in the TEMWC application: Error loading Fixlet: Database Error: Microsofthttp://SQL Server Native Client 10.0SQL ServerLogin failed for user ‘IIS APPPOOL\DefaultAppPool’. (28000:18456)

Thanks Andi

(imported comment written by Lee Wei)

Hi Andi,

Sorry for the issues that you are experiencing.

So you are getting the error this error.

Error from the TakeAction handler in the TEMWC application: Error loading Fixlet: Database Error: Microsofthttp://SQL Server Native Client 10.0SQL ServerLogin failed for user ‘IIS APPPOOL\DefaultAppPool’. (28000:18456)

When we Take Action, the user credential used is the one in the “TEM Server Access Credential” fields in the login screen.

  • The Web Reports user credential is used to Read data, and the TEM Server (as in Console) id is used to Write. So we need to make sure that that they match.
  • I don’t know why the error reference user “IIS APPPOOL\DefaultAppPool”, which is wrong and obviously not what you entered.
  • I wonder if this has to do with an AD credential? I don’t have a setup using AD, so I have yet to test it.

Would you mind contacting me directly at leewei at us.ibm.com and I would like to get to the bottom of this problem.

Lee Wei

(imported comment written by SystemAdmin)

Shouldn’t the second URL point to port 52311 assuming default ports were used?

It’s looking for the TEM server, right?

(imported comment written by SystemAdmin)

Is there any reason not to run this on the bes / webreports server, other than the additional overhead? Is a seperate IIS server required?

(imported comment written by Lee Wei)

John,

Yes an IIS server is required.

The server side code uses .NET and DCOM to access the TEM Server via the platform API.

IIS is needed to host the code, which cannot be done via the Web Reports server.

Lee Wei

(imported comment written by SystemAdmin)

Lee - I guess I didn’t phrase my question correctly. Is there a reason we couldn’t install IIS on the BES / WebReports server and host it there or is a physcially seperate server requireed / recommended for any reason?

(imported comment written by Lee Wei)

John,

Yes, you can install the TEM Server, Web Reports, and IIS (with the TEM Web Console) on the same computer.

Just make sure that we don’t have a port conflict.

Lee Wei

(imported comment written by SystemAdmin)

Lee, can this application be installed on any IIS server that meets the requirements?

ie: does it need to be installed on the Web Reports server?

I wondered how long it would take you to go from Computer Browser to Web Console!

I look forward to testing it!!

(imported comment written by Lee Wei)

Hi Tim,

The app is not installed over Web Reports. The main requirement is IIS.

The link to the Wiki has an architectural diagram.

I learned that IIS is embedded in the Windows operating system. So the IIS version is tied to Windows.

I have tested IIS 5.1 on XP, 6.0 on 2003, and 7.5 on Win7 and Win2008.

What do you mean by “how long it would take you to go from Computer Browser to Web Console”?! :slight_smile:

Lee Wei

(imported comment written by SystemAdmin)

Well dang.

The Fixlets to install the Web Console require version 8.2.1175, and I’m currently only on 8.2.1170.

I suppose it’s time to upgrade, I’ll just have to hold off

upgrading the Mac clients

for now.

(imported comment written by Lee Wei)

Hi Tim,

Why did you think that 8.2.1175 is required?

It should work with any 8.2.x versions.

Let me know where I might have stated this incorrectly.

Lee Wei

(imported comment written by SystemAdmin)

I wasn’t seeing the Fixlet to install the WebConsole eventhough I thought had applied all the pre-reqs, so I looked at the Fixlet and used QnA to evaluate all the relevance clauses, from the intended server.

Did this get changed in .81?

(imported comment written by Lee Wei)

Tim,

The Fixlets are not changed for 0.81. The “TEMWC - Deploy/Install” Fixlet checks for the following items:

  • A workable Windows version
  • TEMWC not already installed
  • .NET Framework 4.0
  • BES Platform Server API
  • IIS

Lee Wei