Where are the server event logs? Help troubleshooting a SQL error?

Kinetic ERP
1

  1. I know we’re using web based 2025.1. I’m not sure if that means we’re on ERP 10, Kinetic, or what. Suggestions? Am I asking this topic in the right place?

  2. Where do I find the server event logs? (no help from company personnel yet).

2a. How do I use the language tag? I tried several ways and found nothing worked.

  1. I have a query I’m pasting into the Convert SQL to BAQ feature. It is below. It reports an error and that I should refer to the server event logs. But until I find those, can you fine people examine this Sub1 + Sub2 code and spot the problem? Sub2 is created in the Sub1 JOIN. MUCH appreciated!

select distinct
e1.PartNum as ePartNum,
e1.QtyPer as eQtyPer,
e1.MtlPartNum as eMtlPartNum,
p.UnitPrice as pUnitPrice,
p.PartDescription as pPartDescription,
(e1.QtyPer * p.UnitPrice) as ExtdUnitPrice,
(sum(e1.QtyPer * p.UnitPrice) over(partition by e1.PartNum)) as SumExtdUnitPrice,
(case when p.PartDescription like ‘%hook%’ then 1 end) as isHook,
e2.is200_2_00xx

from Erp.ECOMtl as e1
left outer join Erp.Part as p on e1.PartNum = p.PartNum
left outer join (
select distinct
e.PartNum as ePartNum,
case when e.PartNum like ‘20[0,2]-00[0-9][0-9]’ then 1 end as is200_2_00xx
from Erp.ECOMtl as e
where e.PartNum = e1.PartNum
) as e2 on
e2.e2PartNum = e1.PartNum and e2.PartNum LIKE ‘2[0-9][0-9]-0[0-9][0-9][0-9]’
where (e1.QtyPer * p.UnitPrice) > 0
order by e1.PartNum, e1.MtlPartNum

2

and

would be my first suspects. SQL-to-BAQ is really bad at reading anything more complicated than an explicit data reference. I’d suggest pasting in everything but the expression text, then add that by hand.

3

Server logs can be accessed via Server File Download. You’ll need to be a security manager or have explicit access to it.

  • Once open, navigate to the Admin directory. Be patient, it takes a minute for the files to load.
  • Click on appserverlogs.
  • Sort by Date Modified and download all of the logs for the current day. I put them in a folder, such as logs/091725.
  • Fire up Notepad++
  • Press CTRL+F to bring up Find, then click the Find in Files tab.
  • Set the directory to the location you downloaded the logs to
  • Enter the correlation ID from the error in the search window.
  • Click Find All.

That’s your error.

1 Like
4

March Madness Omg GIF

For f*ck’s sake, I always thought that the admin folder was empty.

2 Likes
5

It’s very easy to be tricked into thinking that - it used to take close to 5 minutes for the files to load from that directory. We’ve gotten some PRB’s implemented that sped this up significantly over the past few releases.

The other, sexier option (IMO), is to use @GabeFranco’s excellent DevTools application. There’s a button to search the latest app server logs - you just pop in your correlation id, click Search the latest log, and Bob’s your uncle. It’s a work of art.

1 Like