6:38 a.m.
Hi!
I'm wondering how does Guvnor REST api handle Excel decision tables? I'm
using 5.3.1.Final version.
It seems that when I use url for binary e.g.
/http://{guvnor_url}/rest/packages/package_name/assets/excel_table_name/binary/
, I get a source (.xls) file.
And when I use source url e.g.
/http://{guvnor_url}/rest/packages/package_name/assets/excel_table_name/source/
, I get a binary file.
Is this some bug or is it really expected to work this way?
Also, when I try to build binary file (which I get using source url:) )
using knowledge builder I'm getting exceptions, I have tried it in two ways:
1. kbuilder.add(urlResource, ResourceType.DTABLE);
Exception in thread "main"
org.drools.template.parser.DecisionTableParseException: An error occurred
opening the workbook. It is possible that the encoding of the document did
not match the encoding of the reader.
at
org.drools.decisiontable.parser.xls.ExcelParser.parseFile(ExcelParser.java:90)
at
org.drools.decisiontable.SpreadsheetCompiler.compile(SpreadsheetCompiler.java:89)
at
org.drools.decisiontable.SpreadsheetCompiler.compile(SpreadsheetCompiler.java:68)
at
org.drools.decisiontable.DecisionTableProviderImpl.compileStream(DecisionTableProviderImpl.java:38)
at
org.drools.decisiontable.DecisionTableProviderImpl.loadFromInputStream(DecisionTableProviderImpl.java:21)
at
org.drools.compiler.DecisionTableFactory.loadFromInputStream(DecisionTableFactory.java:18)
at
org.drools.compiler.PackageBuilder.addKnowledgeResource(PackageBuilder.java:613)
at
org.drools.builder.impl.KnowledgeBuilderImpl.add(KnowledgeBuilderImpl.java:37)
at Main.main(Main.java:101)
Caused by: jxl.read.biff.BiffException: Unable to recognize OLE stream
at jxl.read.biff.CompoundFile.<init>(CompoundFile.java:116)
at jxl.read.biff.File.<init>(File.java:127)
at jxl.Workbook.getWorkbook(Workbook.java:268)
at
org.drools.decisiontable.parser.xls.ExcelParser.parseFile(ExcelParser.java:75)
... 8 more
2. kbuilder.add(urlResource, ResourceType.DRL);
java.lang.IndexOutOfBoundsException: Index: 693, Size: 693
at java.util.ArrayList.get(ArrayList.java:352)
at org.antlr.runtime.CommonTokenStream.LT(CommonTokenStream.java:103)
at org.drools.lang.ParserHelper.reportError(ParserHelper.java:386)
at org.drools.lang.DRLParser.compilationUnit(DRLParser.java:182)
at org.drools.compiler.DrlParser.compile(DrlParser.java:225)
at org.drools.compiler.DrlParser.parse(DrlParser.java:136)
at org.drools.compiler.DrlParser.parse(DrlParser.java:141)
at
org.drools.compiler.PackageBuilder.addPackageFromDrl(PackageBuilder.java:394)
at
org.drools.compiler.PackageBuilder.addKnowledgeResource(PackageBuilder.java:586)
at
org.drools.builder.impl.KnowledgeBuilderImpl.add(KnowledgeBuilderImpl.java:37)
at Main.main(Main.java:101)
Exception in thread "main" java.lang.RuntimeException:
org.drools.compiler.DroolsParserException: Unexpected exception raised while
parsing. This is a bug. Please contact the Development team :
Index: 693, Size: 693
at
org.drools.compiler.PackageBuilder.addKnowledgeResource(PackageBuilder.java:692)
at
org.drools.builder.impl.KnowledgeBuilderImpl.add(KnowledgeBuilderImpl.java:37)
at Main.main(Main.java:101)
Caused by: org.drools.compiler.DroolsParserException: Unexpected exception
raised while parsing. This is a bug. Please contact the Development team :
Index: 693, Size: 693
at org.drools.compiler.DrlParser.compile(DrlParser.java:242)
at org.drools.compiler.DrlParser.parse(DrlParser.java:136)
at org.drools.compiler.DrlParser.parse(DrlParser.java:141)
at
org.drools.compiler.PackageBuilder.addPackageFromDrl(PackageBuilder.java:394)
at
org.drools.compiler.PackageBuilder.addKnowledgeResource(PackageBuilder.java:586)
... 2 more
--
View this message in context:
http://drools.46999.n3.nabble.com/Guvnor-REST-API-and-XLS-decision-tables...
Sent from the Drools: User forum mailing list archive at Nabble.com.
10:20 p.m.
On 2012/5/14 19:38, anchi wrote:
Hi!
I'm wondering how does Guvnor REST api handle Excel decision tables? I'm
using 5.3.1.Final version.
It seems that when I use url for binary e.g.
/http://{guvnor_url}/rest/packages/package_name/assets/excel_table_name/binary/
, I get a source (.xls) file.
And when I use source url e.g.
/http://{guvnor_url}/rest/packages/package_name/assets/excel_table_name/source/
, I get a binary file.
Is this some bug or is it really expected to work this way?
Hi, below is from the
documentation:
/packages/{packageName}/assets/{assetName}/source GET plain/text
none Returns the content of rule asset {assetName} contained in package
{packageName}. If this is a binary asset, returns the binary data as a
byte array. If the asset {assetName} does not exist, status 404 is
returned.
Essentially this means /packages/{packageName}/assets/{assetName}/source
and /packages/{packageName}/assets/{assetName}/binary both return the
same content, which is a binary stream of the xls file in your case. The
only difference between
/packages/{packageName}/assets/{assetName}/source and
/packages/{packageName}/assets/{assetName}/binary is that
/packages/{packageName}/assets/{assetName}/binary has the returned file
extension set, but /packages/{packageName}/assets/{assetName}/source
does not.
Also, when I try to build binary file (which I get using source url:) )
using knowledge builder I'm getting exceptions, I have tried it in two ways:
To
verify if the file returned from REST is corrupted or not, you can
open it with Excel. If it works, then its sth else wrong with your
KBuilder client.
Cheers,
Jervis
1. kbuilder.add(urlResource, ResourceType.DTABLE);
Exception in thread "main"
org.drools.template.parser.DecisionTableParseException: An error occurred
opening the workbook. It is possible that the encoding of the document did
not match the encoding of the reader.
at
org.drools.decisiontable.parser.xls.ExcelParser.parseFile(ExcelParser.java:90)
at
org.drools.decisiontable.SpreadsheetCompiler.compile(SpreadsheetCompiler.java:89)
at
org.drools.decisiontable.SpreadsheetCompiler.compile(SpreadsheetCompiler.java:68)
at
org.drools.decisiontable.DecisionTableProviderImpl.compileStream(DecisionTableProviderImpl.java:38)
at
org.drools.decisiontable.DecisionTableProviderImpl.loadFromInputStream(DecisionTableProviderImpl.java:21)
at
org.drools.compiler.DecisionTableFactory.loadFromInputStream(DecisionTableFactory.java:18)
at
org.drools.compiler.PackageBuilder.addKnowledgeResource(PackageBuilder.java:613)
at
org.drools.builder.impl.KnowledgeBuilderImpl.add(KnowledgeBuilderImpl.java:37)
at Main.main(Main.java:101)
Caused by: jxl.read.biff.BiffException: Unable to recognize OLE stream
at jxl.read.biff.CompoundFile.<init>(CompoundFile.java:116)
at jxl.read.biff.File.<init>(File.java:127)
at jxl.Workbook.getWorkbook(Workbook.java:268)
at
org.drools.decisiontable.parser.xls.ExcelParser.parseFile(ExcelParser.java:75)
... 8 more
2. kbuilder.add(urlResource, ResourceType.DRL);
java.lang.IndexOutOfBoundsException: Index: 693, Size: 693
at java.util.ArrayList.get(ArrayList.java:352)
at org.antlr.runtime.CommonTokenStream.LT(CommonTokenStream.java:103)
at org.drools.lang.ParserHelper.reportError(ParserHelper.java:386)
at org.drools.lang.DRLParser.compilationUnit(DRLParser.java:182)
at org.drools.compiler.DrlParser.compile(DrlParser.java:225)
at org.drools.compiler.DrlParser.parse(DrlParser.java:136)
at org.drools.compiler.DrlParser.parse(DrlParser.java:141)
at
org.drools.compiler.PackageBuilder.addPackageFromDrl(PackageBuilder.java:394)
at
org.drools.compiler.PackageBuilder.addKnowledgeResource(PackageBuilder.java:586)
at
org.drools.builder.impl.KnowledgeBuilderImpl.add(KnowledgeBuilderImpl.java:37)
at Main.main(Main.java:101)
Exception in thread "main" java.lang.RuntimeException:
org.drools.compiler.DroolsParserException: Unexpected exception raised while
parsing. This is a bug. Please contact the Development team :
Index: 693, Size: 693
at
org.drools.compiler.PackageBuilder.addKnowledgeResource(PackageBuilder.java:692)
at
org.drools.builder.impl.KnowledgeBuilderImpl.add(KnowledgeBuilderImpl.java:37)
at Main.main(Main.java:101)
Caused by: org.drools.compiler.DroolsParserException: Unexpected exception
raised while parsing. This is a bug. Please contact the Development team :
Index: 693, Size: 693
at org.drools.compiler.DrlParser.compile(DrlParser.java:242)
at org.drools.compiler.DrlParser.parse(DrlParser.java:136)
at org.drools.compiler.DrlParser.parse(DrlParser.java:141)
at
org.drools.compiler.PackageBuilder.addPackageFromDrl(PackageBuilder.java:394)
at
org.drools.compiler.PackageBuilder.addKnowledgeResource(PackageBuilder.java:586)
... 2 more
--
View this message in context:
http://drools.46999.n3.nabble.com/Guvnor-REST-API-and-XLS-decision-tables...
Sent from the Drools: User forum mailing list archive at Nabble.com.
_______________________________________________
rules-users mailing list
rules-users(a)lists.jboss.org
https://lists.jboss.org/mailman/listinfo/rules-users
6:06 a.m.
Thanks for your reply. Things are clearer now! For some reason I expected
inverse behavior for /binary and /source, but now you've made it clear.
I have tried your advice to open a file returned from REST /source with
Excel. After renaming it (adding a proper file extension), Excel is not able
to open it, i.e. a file I get from Guvnor is corrupted which causes kbuilder
exceptions.
--
View this message in context:
http://drools.46999.n3.nabble.com/Guvnor-REST-API-and-XLS-decision-tables...
Sent from the Drools: User forum mailing list archive at Nabble.com.
10:13 p.m.
anchi wrote:
Thanks for your reply. Things are clearer now! For some reason I
expected
inverse behavior for /binary and /source, but now you've made it clear.
I have tried your advice to open a file returned from REST /source with
Excel. After renaming it (adding a proper file extension), Excel is not able
to open it, i.e. a file I get from Guvnor is corrupted which causes kbuilder
exceptions.
Hi how did you put this XLS file into Guvnor in the first place? Through
REST interface or through Guvnor UI? You can verify if the XLS is
corrupted in the repository by downloading it through Guvnor UI. If it
is corrupted as well, then probably sth went wrong when you uploaded the
file.
Cheers,
Jervis
--
View this message in context:
http://drools.46999.n3.nabble.com/Guvnor-REST-API-and-XLS-decision-tables...
Sent from the Drools: User forum mailing list archive at Nabble.com.
_______________________________________________
rules-users mailing list
rules-users(a)lists.jboss.org
https://lists.jboss.org/mailman/listinfo/rules-users
2:15 a.m.
No it is not corrupted, I've uploaded it through Guvnor web console. When I
download it directly through Guvnor UI, I get a valid file.
Also when I reach it through REST API using:
http://{guvnor_url}/rest/packages/{package}/assets/{xls_name}/binary , I
also get a valid file.
The only case when I get a corrupted file is when I use:
http://{guvnor_url}/rest/packages/{package}/assets/{xls_name}/source
I have adjusted my application to check for this special case, and when file
extension is .xls i use /binary URL (for other assets I'm using /source
url), but I'm still interested on how to get xls through REST api using
http://{guvnor_url}/rest/packages/{package}/assets/{xls_name}/source
--
View this message in context:
http://drools.46999.n3.nabble.com/Guvnor-REST-API-and-XLS-decision-tables...
Sent from the Drools: User forum mailing list archive at Nabble.com.
4:27 a.m.
anchi wrote:
No it is not corrupted, I've uploaded it through Guvnor web
console. When I
download it directly through Guvnor UI, I get a valid file.
Also when I reach it through REST API using:
http://{guvnor_url}/rest/packages/{package}/assets/{xls_name}/binary , I
also get a valid file.
The only case when I get a corrupted file is when I use:
http://{guvnor_url}/rest/packages/{package}/assets/{xls_name}/source
I have adjusted my application to check for this special case, and when file
extension is .xls i use /binary URL (for other assets I'm using /source
url), but I'm still interested on how to get xls through REST api using
http://{guvnor_url}/rest/packages/{package}/assets/{xls_name}/source
Hi it is not safe to get the binary content by using
http://{guvnor_url}/rest/packages/{package}/assets/{xls_name}/source. As
the Guvnor has no idea what charset encoding is used by that binary
file. When Guvnor converts the binary to a String representation, it can
only use the platform default charset. If this is the different encoding
than the original one, then your file will be corrupted.
Make sure you use
http://{guvnor_url}/rest/packages/{package}/assets/{xls_name}/binary
instead to retrieve the binary content.
Cheers,
Jervis
--
View this message in context:
http://drools.46999.n3.nabble.com/Guvnor-REST-API-and-XLS-decision-tables...
Sent from the Drools: User forum mailing list archive at Nabble.com.
_______________________________________________
rules-users mailing list
rules-users(a)lists.jboss.org
https://lists.jboss.org/mailman/listinfo/rules-users
9:27 a.m.
Thanks, I'll listen to your advice and switch to downloading binary asset
content.
--
View this message in context:
http://drools.46999.n3.nabble.com/Guvnor-REST-API-and-XLS-decision-tables...
Sent from the Drools: User forum mailing list archive at Nabble.com.
4660
days inactive
4663
days old
6 comments
2 participants
participants (2)
-
anchi -
Jervis Liu