Labor Edit Report E905.605

Yahoo Archive
1
Did you every find someone who did a Crystal version of the Labor Edit report?

Did you end up creating one?
If yes, may I obtain it?

--- In vantage@yahoogroups.com, Paul Lipham <pml@...> wrote:
>
> Does anyone have a decent labor edit report in Crystal for Epicor 905? The one they have out of the box is a text report that can't be modified. They didn't put the resource ID on the detail. It would be nice to see what equipment was used for a job. Also, it's hard to read and needs to be landscape or something.
>
> Thanks,
>
>
> Paul Lipham
> Information Technology Manager
> Alabama Specialty Products, Inc.
> 152 Metal Samples Road
> Munford, AL 36268
>
>
>
>
> [Non-text portions of this message have been removed]
>
2
I have called tech support and they so far, as a lil stumped. I am hoping to
hear back but thought I would see if anyone else has seen this.

So here is the simple problem,

The app servers all fail to start and in my logs, I get the following:
/03@15:34:49.884-0700] P-004708 T-004308 2 AS CONN Connected to
database mfgsyssh, single user. (9542)
[11/10/03@15:34:49.911-0700] P-004708 T-004308 1 AS -- Login was denied
because of an authorization error. (6179)
[11/10/03@15:34:49.911-0700] P-004708 T-004308 1 AS -- 28000:
[Microsoft][SQL Server Native Client 10.0][SQL Server]Login failed for user
'MAIN\EPICORAPP$'.
[11/10/03@15:34:49.911-0700] P-004708 T-004308 1 AS -- Failed to connect to
the MSS database. (6142)
[11/10/03@15:34:49.911-0700] P-004708 T-004308 2 AS CONN Failed to
connect to the MSS database. (6142)
[11/10/03@15:34:49.912-0700] P-004708 T-004308 1 AS -- Error initializing
the application server. (5479)
[11/10/03@15:34:49.914-0700] P-004708 T-004308 2 AS AS Application Server
Shutdown. (5476)

Here is what happened.

My app server is EpicorAPP and my DB server is EpicorDB. I converted my
servers from p2v in hopes of making a couple of virtual development boxes. I
asked VMWare to rename the machines but i guess they didnt. So when I turned
on the Virtual machines, they came up as the same name as my physical
machines. DAMN! Instantly I turned off my virtual boxes but the damage was
done. I was no longer able to RDP to my production servers.

Next thing I tried was to simply reboot them. That didnt work, still no RDP.

So then I shut them down, cleared the DNS information on them and turned
them back on. RDP Works
Login error. Something about a trust relationship. Googled it and said to
rejoin them to the domain.

Rejoined them to the domain, rebooted, I can login via rdp, onto the
domain!!!

Now getting the app servers to fire ...that was the last problem.

Thats where I am at now.

Any ideas?

Thanks
3
Nick,

Change the Open Edge Admin Service to Logon as a User that has access to the SQL DB.
Stop all App Servers, Stop the Admin Service , Restart it and this should solve your issue.
You could also check the DSN will test and connect correctly for the specific environment.

Regards,
Stephen

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Nick
Sent: 03 October 2011 23:49
To: vantage@yahoogroups.com
Subject: [Vantage] Technical help...



I have called tech support and they so far, as a lil stumped. I am hoping to
hear back but thought I would see if anyone else has seen this.

So here is the simple problem,

The app servers all fail to start and in my logs, I get the following:
/03@15:34:49.884-0700<mailto:/03@15:34:49.884-0700>] P-004708 T-004308 2 AS CONN Connected to
database mfgsyssh, single user. (9542)
[11/10/03@15:34:49.911-0700] P-004708 T-004308 1 AS -- Login was denied
because of an authorization error. (6179)
[11/10/03@15:34:49.911-0700] P-004708 T-004308 1 AS -- 28000:
[Microsoft][SQL Server Native Client 10.0][SQL Server]Login failed for user
'MAIN\EPICORAPP$'.
[11/10/03@15:34:49.911-0700] P-004708 T-004308 1 AS -- Failed to connect to
the MSS database. (6142)
[11/10/03@15:34:49.911-0700] P-004708 T-004308 2 AS CONN Failed to
connect to the MSS database. (6142)
[11/10/03@15:34:49.912-0700] P-004708 T-004308 1 AS -- Error initializing
the application server. (5479)
[11/10/03@15:34:49.914-0700] P-004708 T-004308 2 AS AS Application Server
Shutdown. (5476)

Here is what happened.

My app server is EpicorAPP and my DB server is EpicorDB. I converted my
servers from p2v in hopes of making a couple of virtual development boxes. I
asked VMWare to rename the machines but i guess they didnt. So when I turned
on the Virtual machines, they came up as the same name as my physical
machines. DAMN! Instantly I turned off my virtual boxes but the damage was
done. I was no longer able to RDP to my production servers.

Next thing I tried was to simply reboot them. That didnt work, still no RDP.

So then I shut them down, cleared the DNS information on them and turned
them back on. RDP Works
Login error. Something about a trust relationship. Googled it and said to
rejoin them to the domain.

Rejoined them to the domain, rebooted, I can login via rdp, onto the
domain!!!

Now getting the app servers to fire ...that was the last problem.

Thats where I am at now.

Any ideas?

Thanks



[Non-text portions of this message have been removed]
4
Is Main your domain or your local server name?

As someone else said, there is a problem with authentication to your SQL server.

First, you should login to your SQL server and check the Security\Logins section to make sure there is a Domain user who has Sysadmin privileges on the server. Then, go back to your appserver and make sure that there is a domain user set for the AdminService for OpenEdge 10.2A, assuming you are 9.05 anyway, otherwise it is a different version but same service. Open the service and check the "Log On" tab and set the service to use that user with that password to run the Admin Service.

That should solve this problem.


Ned
Alternative Technology Partners



-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Nick
Sent: Monday, October 03, 2011 6:49 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Technical help...

I have called tech support and they so far, as a lil stumped. I am hoping to hear back but thought I would see if anyone else has seen this.

So here is the simple problem,

The app servers all fail to start and in my logs, I get the following:
/03@15:34:49.884-0700] P-004708 T-004308 2 AS CONN Connected to
database mfgsyssh, single user. (9542)
[11/10/03@15:34:49.911-0700] P-004708 T-004308 1 AS -- Login was denied because of an authorization error. (6179) [11/10/03@15:34:49.911-0700] P-004708 T-004308 1 AS -- 28000:
[Microsoft][SQL Server Native Client 10.0][SQL Server]Login failed for user 'MAIN\EPICORAPP$'.
[11/10/03@15:34:49.911-0700] P-004708 T-004308 1 AS -- Failed to connect to the MSS database. (6142)
[11/10/03@15:34:49.911-0700] P-004708 T-004308 2 AS CONN Failed to
connect to the MSS database. (6142)
[11/10/03@15:34:49.912-0700] P-004708 T-004308 1 AS -- Error initializing the application server. (5479) [11/10/03@15:34:49.914-0700] P-004708 T-004308 2 AS AS Application Server Shutdown. (5476)

Here is what happened.

My app server is EpicorAPP and my DB server is EpicorDB. I converted my servers from p2v in hopes of making a couple of virtual development boxes. I asked VMWare to rename the machines but i guess they didnt. So when I turned on the Virtual machines, they came up as the same name as my physical machines. DAMN! Instantly I turned off my virtual boxes but the damage was done. I was no longer able to RDP to my production servers.

Next thing I tried was to simply reboot them. That didnt work, still no RDP.

So then I shut them down, cleared the DNS information on them and turned them back on. RDP Works Login error. Something about a trust relationship. Googled it and said to rejoin them to the domain.

Rejoined them to the domain, rebooted, I can login via rdp, onto the domain!!!

Now getting the app servers to fire ...that was the last problem.

Thats where I am at now.

Any ideas?

Thanks




------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
5
Stephen,

you nailed it!! did that and its all working again. Thanks so much!!




On Tue, 4 Oct 2011 00:18:56 +0000
Stephen Edginton <stephene@...> wrote:
Nick,

Change the Open Edge Admin Service to Logon as a User
that has access to the SQL DB.
Stop all App Servers, Stop the Admin Service , Restart it
and this should solve your issue.
You could also check the DSN will test and connect
correctly for the specific environment.

Regards,
Stephen

From: vantage@yahoogroups.com
[mailto:vantage@yahoogroups.com] On Behalf Of Nick
Sent: 03 October 2011 23:49
To: vantage@yahoogroups.com
Subject: [Vantage] Technical help...



I have called tech support and they so far, as a lil
stumped. I am hoping to
hear back but thought I would see if anyone else has seen
this.

So here is the simple problem,

The app servers all fail to start and in my logs, I get
the following:
/03@15:34:49.884-0700<mailto:/03@15:34:49.884-0700>]
P-004708 T-004308 2 AS CONN Connected to
database mfgsyssh, single user. (9542)
[11/10/03@15:34:49.911-0700] P-004708 T-004308 1 AS --
Login was denied
because of an authorization error. (6179)
[11/10/03@15:34:49.911-0700] P-004708 T-004308 1 AS --
28000:
[Microsoft][SQL Server Native Client 10.0][SQL
Server]Login failed for user
'MAIN\EPICORAPP$'.
[11/10/03@15:34:49.911-0700] P-004708 T-004308 1 AS --
Failed to connect to
the MSS database. (6142)
[11/10/03@15:34:49.911-0700] P-004708 T-004308 2 AS CONN
Failed to
connect to the MSS database. (6142)
[11/10/03@15:34:49.912-0700] P-004708 T-004308 1 AS --
Error initializing
the application server. (5479)
[11/10/03@15:34:49.914-0700] P-004708 T-004308 2 AS AS
Application Server
Shutdown. (5476)

Here is what happened.

My app server is EpicorAPP and my DB server is EpicorDB.
I converted my
servers from p2v in hopes of making a couple of virtual
development boxes. I
asked VMWare to rename the machines but i guess they
didnt. So when I turned
on the Virtual machines, they came up as the same name as
my physical
machines. DAMN! Instantly I turned off my virtual boxes
but the damage was
done. I was no longer able to RDP to my production
servers.

Next thing I tried was to simply reboot them. That didnt
work, still no RDP.

So then I shut them down, cleared the DNS information on
them and turned
them back on. RDP Works
Login error. Something about a trust relationship.
Googled it and said to
rejoin them to the domain.

Rejoined them to the domain, rebooted, I can login via
rdp, onto the
domain!!!

Now getting the app servers to fire ...that was the last
problem.

Thats where I am at now.

Any ideas?

Thanks



[Non-text portions of this message have been removed]
6
I was wondering if anyone using Wasp Barcode Maker Pro to generate 2D barcodes in Crystal Reports? They have the 10 PC license version which is pretty affordable.



Mike Tonoyan / Natel Engr.

mtonoyan@...


______________________________________________________________________
Notice: This email transmission may contain confidential information and is intended only for the person(s) named. Any use, copying or disclosure to/by any other person(s) is strictly prohibited. By accepting this information, recipients confirm that they understand and will comply with all applicable ITAR and EAR requirements.
______________________________________________________________________


[Non-text portions of this message have been removed]
7
Due to special characters used in part numbers, part lot numbers, and
space limitations we have to use 2D barcodes. I think DataMatrix is the
way to go for our needs.



Mike Tonoyan / Natel Engr.

mtonoyan@...



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of cooner_55421
Sent: Monday, October 10, 2011 11:39 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Is anyone using Wasp Barcode Maker Pro?





I remember some testing was done here by one of the guys of both Wasp &
IDAutomation.
He went with IDAutomation, I don't know why.

I "inherited" the responsibility and it has worked well in most cases.

BTW.. we had some trouble with scanners when we upgraded.
Turned out to be unrelated to the bar code font but...
I set up some a couple reports using the Dataworks Bar 39.
Concatenated fields, keystrokes, etc...
After that I kind of wondered why we bothered to buy any extra bar code
software to begin with.

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"Mike Tonoyan" <mtonoyan@...> wrote:
>
> I was wondering if anyone using Wasp Barcode Maker Pro to generate 2D
barcodes in Crystal Reports? They have the 10 PC license version which
is pretty affordable.
>
>
>
> Mike Tonoyan / Natel Engr.
>
> mtonoyan@...
>
>
> __________________________________________________________
> Notice: This email transmission may contain confidential information
and is intended only for the person(s) named. Any use, copying or
disclosure to/by any other person(s) is strictly prohibited. By
accepting this information, recipients confirm that they understand and
will comply with all applicable ITAR and EAR requirements.
> __________________________________________________________
>
>
> [Non-text portions of this message have been removed]
>




______________________________________________________________________
Notice: This email transmission may contain confidential information and is intended only for the person(s) named. Any use, copying or disclosure to/by any other person(s) is strictly prohibited. By accepting this information, recipients confirm that they understand and will comply with all applicable ITAR and EAR requirements.
______________________________________________________________________

[Non-text portions of this message have been removed]
8
Does anyone have a decent labor edit report in Crystal for Epicor 905? The one they have out of the box is a text report that can't be modified. They didn't put the resource ID on the detail. It would be nice to see what equipment was used for a job. Also, it's hard to read and needs to be landscape or something.

Thanks,


Paul Lipham
Information Technology Manager
Alabama Specialty Products, Inc.
152 Metal Samples Road
Munford, AL 36268




[Non-text portions of this message have been removed]