/build/static/layout/Breadcrumb_cap_w.png

Inventory - All Details Error

Anyone else having this error? I'm new to this an not a scripter so I am not going to be able to debug this on my own. It looks like some info may just be in there twice on accident, but I don't know where to look in the Jasper report (or SQL) script for this info and how to tell it apart from the rest.

Exception while running report. net.sf.jasperreports.engine.JRException: Duplicate declaration of field : ID[/align]

0 Comments   [ + ] Show comments

Answers (7)

Posted by: Gearshock 12 years ago
Senior Yellow Belt
0
Much like my other question, I suppose I am on my own here? In the instance that someone reads this but not the other, KACE support has failed as well by not being present for chat and not responding to email. So is there some other location or forum where I can go to get answers?
Posted by: scottlutz 12 years ago
Orange Senior Belt
0
Can you paste the SQL from your report in here so we can have a look?
Posted by: Gearshock 12 years ago
Senior Yellow Belt
0
Sure!

select *, MACHINE.NAME as MNAME, MACHINE_DISKS.NAME as DNAME from (MACHINE,MACHINE_DISKS, MACHINE_NICS)
where MACHINE.ID = MACHINE_DISKS.ID and MACHINE.ID = MACHINE_NICS.ID
order by MNAME


Thanks for responding, I was afraid I wasn't going to get anything since it had been a couple days. Is this just not a very active place? The amount of posts are something of an indicator but the views are high.
Posted by: scottlutz 12 years ago
Orange Senior Belt
0
What are you trying to get out of this report? If I run it in my SQL editor, I get a lot of data, which seems to be more than your report. have you tried to execute this in MySQL Workbench to test the results?

I know that the version you are on is older now, with a reporting engine (JasperSoft) that is deprecated. If this error keeps appearing, you may want to try pasting it into a new SQL report to get your data out.

also, there is plenty of activity here, but your original post didn't really give much to go with. The more you provide, the more likely to get a quick, quality response.
Posted by: Gearshock 12 years ago
Senior Yellow Belt
0
Sorry about not giving enough info, I thought the error and title would've sufficed for an idea of what was happening. I believe this is one of the built-in reports, but it is supposed to show our inventory with all the details. When you say old version, do you mean the K1000 version? The guys in charge of bringing the box up to 5.3 think they will have it up before the month is out. Would that alleviate some of the issues?

I know this is going to be a pain and seem backwards but I don't know any SQL. I was brought on as an intern to try and learn the K1000 system so that I can train them on it. They want to be able to set up some custom reports though and have people familiar with SQL that I haven't met yet but found out about today. Should I run it by them? I've only spent about 15 hours with this box. Most of that has been reading whitepapers though.
Posted by: scottlutz 12 years ago
Orange Senior Belt
0
Ok, so I had a look at the report on my system, and it is there, even on 5.3. Are you trying to get data out in a format other than csv?

I would open a support ticket, and they will be able to help you out. Chat is good, but there is no follow-up until your spot in the queue is addressed.

You can do this from any page in the K1000 console at the bottom right corner.

HTH
Posted by: Gearshock 12 years ago
Senior Yellow Belt
0
I think it fails even trying to get it out in CSV but I can't directly recall if I tried CSV. I think I have but I've mainly been doing PDF, TXT, and HTML. I've only used CSV for a handful of things. I suppose I will create a ticket then. Thanks for the help though, I appreciate you trying to direct me to a solution.
Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

View more:

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ