Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 727
  • Last Modified:

McKesson home care application 12.3.4 errors with Xenapp 6.5 as published app

We are running McKessons Horizon Homecare 12.3.4 application.  The program works fine when launched as a published app on our legacy Citrix 4.5 presentation server.
we are building a new environment on server 2008r2 with xenapp 6.5 RU1.  The McKesson app runs fine on the server but as a published app bill processing and oasis module have issues, in bill processing to EDI, we get an error on BILREG.exe ("Input file was not opened").
I tested this same published app using the same client programs but using a different (Test) database and did not experiance the error.  The scenario does not make sense since there are no errors runing on the production DB at the host server.
so, it appears to be a conflict with published app and the one specific database.

I hope someone has seen this and is familiar with xenapp and McKesson.

Thank you
Wayne
0
wlasner
Asked:
wlasner
  • 5
  • 2
  • 2
2 Solutions
 
Ayman BakrSenior ConsultantCommented:
What is the database? DB server OS? Version?
Any events on the server (not only the DB but also the XenApp server)? Please post them here.
0
 
wlasnerDirector, ITAuthor Commented:
DB Server is SQL 2008
The application produces an error:
"An unidentified error has occurred while executing BILREG.EXE 12.3"
"Error Number: 2147352567"
"Input file was not opened"

I cleared the error logs on the citrix app server and re-produced the error.  there are no events logged for this issue.
0
 
joharderCommented:
It's possible that the app has a 16-bit component that is incompatible with the x64 OS.  Depending on your activity within the app, you may only call that component when executing a very specific action.

You can specifically check the bilreg.exe.  Look at the properties of the exe.

In addition, you can run the app through AppDNA.  If you go to www.citrix.com/appdna, you can sign up for a free eval and test the app.
0
NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

 
wlasnerDirector, ITAuthor Commented:
ok, I will look into that...
FYI, the McKesson app is running on a citrix 4.5 environment on a x64 system.  The variable here is the xenapp 6.5
0
 
Ayman BakrSenior ConsultantCommented:
On XenApp 6.5 are you facing the issue on the existing DB? I.e are you connecting your new environment to the existing DB or to a fresh DB?

I am asking this question because you say on XenApp 6.5 and test DB this issue doesn't exist. So I tend to believe their is something breaking between XenApp 6.5 and the existing DB.

Is my reasoning correct?
0
 
wlasnerDirector, ITAuthor Commented:
could make sense except that this is a multi module program - think of it like quickbooks, where the program loads ok, you can add employees, pay bills but when you try to run a report or export a file in a/p you get an error but the same tasks in gl do not produce an error.
0
 
joharderCommented:
I again recommend using AppDNA for this purpose.  I got involved with troubleshooting a similar app yesterday afternoonthat got all greens from AppDNA from the XenApp analysis but lots of red from the OS analysis.  We were so accustomed to just looking at the XenApp analysis that the OS analysis was overlooked.

AppDNA is very easy to set up.  (Install OS, install AppDNA itself and that's pretty much it.)  If the app is provided in an MSI installer, you just browse to it and then click analyze.  If the app is a setup.exe, you must first create an MSI installer.
0
 
wlasnerDirector, ITAuthor Commented:
ok, I will look into this...  I did do a test by using windows RDP and had the same issue.  Citrix maintains it is not their problem because it bahaved the same under windows RDP.
0
 
wlasnerDirector, ITAuthor Commented:
thank you
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

  • 5
  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now