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

Comments

Please log in to comment

Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.

Answers

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?
Answered 02/03/2012 by: Gearshock
Senior Yellow Belt

Please log in to comment
0
Can you paste the SQL from your report in here so we can have a look?
Answered 02/03/2012 by: scottlutz
Orange Senior Belt

Please log in to comment
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.
Answered 02/03/2012 by: Gearshock
Senior Yellow Belt

Please log in to comment
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.
Answered 02/03/2012 by: scottlutz
Orange Senior Belt

Please log in to comment
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.
Answered 02/03/2012 by: Gearshock
Senior Yellow Belt

Please log in to comment
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
Answered 02/03/2012 by: scottlutz
Orange Senior Belt

Please log in to comment
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.
Answered 02/03/2012 by: Gearshock
Senior Yellow Belt

Please log in to comment
Answer this question or Comment on this question for clarity