Hi, I'm facing below error while I'm generating my API. "Input" is my sheet name from where I am linking in/out parameters.
Unknown sheet name(when getting sheet index): Input
Full logs:
021-11-08 21:00:52.853 [main] INFO com.axisoft.alchemyj.base.configuration.cwz.dceio - ***Tasklet Step (StudioOutputEntityDefConfigParsingStep) Start***
2021-11-08 21:00:52.868 [main] INFO com.axisoft.alchemyj.base.logging.lpswjq - Parsing studio output configuration file: WaterDewpoint-20211017.xlsm/AlchemyJ Package Object Definition.json
2021-11-08 21:00:52.993 [main] ERROR com.axisoft.alchemyj.base.configuration.cwz.dceio - ***Tasklet Step (StudioOutputEntityDefConfigParsingStep) Failure***
java.lang.IllegalArgumentException: Unknown sheet name(when getting sheet index): Input
at com.axisoft.alchemyj.compilation.tool.cvbcgm.cwz.cvbcgm.cxauqy.zge16s(Unknown Source)
at com.axisoft.alchemyj.compiler.job.studio.config.parsing.wblevel.StudioOutputEntityDefConfigParsingTasklet.zge16s(Unknown Source)
at com.axisoft.alchemyj.compiler.job.studio.config.parsing.wblevel.StudioOutputEntityDefConfigParsingTasklet.q7igtq(Unknown Source)
at java.util.LinkedHashMap.forEach(Unknown Source)
at com.axisoft.alchemyj.compiler.job.studio.config.parsing.wblevel.StudioOutputEntityDefConfigParsingTasklet.q7igtq(Unknown Source)
at com.axisoft.alchemyj.compilation.tool.cvbcgm.cwz.cvbcgm.czqubh.q7igtq(Unknown Source)
at java.util.LinkedHashMap$LinkedValues.forEach(Unknown Source)
at com.axisoft.alchemyj.compilation.tool.cvbcgm.cwz.cvbcgm.dhw8.sohko(Unknown Source)
at com.axisoft.alchemyj.compilation.tool.cvbcgm.cwz.cvbcgm.czqubh.xeyb5ks(Unknown Source)
at com.axisoft.alchemyj.compiler.job.studio.config.parsing.wblevel.StudioOutputEntityDefConfigParsingTasklet.cbrz(Unknown Source)
at com.axisoft.alchemyj.compiler.job.studio.config.parsing.wblevel.StudioOutputEntityDefConfigParsingTasklet.slocax(Unknown Source)
at com.axisoft.alchemyj.compiler.job.studio.config.parsing.wblevel.StudioOutputEntityDefConfigParsingTasklet.ean6g(Unknown Source)
at com.axisoft.alchemyj.compilation.tool.job.base.AbstractTasklet.execute(Unknown Source)
at com.axisoft.alchemyj.compilation.tool.job.base.AbstractTasklet$$FastClassBySpringCGLIB$$4a5e324d.invoke(<generated>)
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:746)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:100)
at com.axisoft.alchemyj.base.configuration.cwz.dceio.doAroundAdvice(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:644)
at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:633)
at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:70)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:174)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:688)
at com.axisoft.alchemyj.compiler.job.studio.config.parsing.wblevel.StudioOutputEntityDefConfigParsingTasklet$$EnhancerBySpringCGLIB$$428b33c0.execute(<generated>)
at com.axisoft.alchemyj.compilation.tool.job.base.AbstractTasklet$$FastClassBySpringCGLIB$$4a5e324d.invoke(<generated>)
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:746)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:136)
at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:124)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:688)
at com.axisoft.alchemyj.compiler.job.studio.config.parsing.wblevel.StudioOutputEntityDefConfigParsingTasklet$$EnhancerBySpringCGLIB$$ef300d4a.execute(<generated>)
at org.springframework.batch.core.step.tasklet.TaskletStep$ChunkTransactionCallback.doInTransaction(TaskletStep.java:406)
at org.springframework.batch.core.step.tasklet.TaskletStep$ChunkTransactionCallback.doInTransaction(TaskletStep.java:330)
at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:140)
at org.springframework.batch.core.step.tasklet.TaskletStep$2.doInChunkContext(TaskletStep.java:272)
at org.springframework.batch.core.scope.context.StepContextRepeatCallback.doInIteration(StepContextRepeatCallback.java:81)
at org.springframework.batch.repeat.support.RepeatTemplate.getNextResult(RepeatTemplate.java:375)
at org.springframework.batch.repeat.support.RepeatTemplate.executeInternal(RepeatTemplate.java:215)
at org.springframework.batch.repeat.support.RepeatTemplate.iterate(RepeatTemplate.java:145)
at org.springframework.batch.core.step.tasklet.TaskletStep.doExecute(TaskletStep.java:257)
at org.springframework.batch.core.step.AbstractStep.execute(AbstractStep.java:200)
at org.springframework.batch.core.job.SimpleStepHandler.handleStep(SimpleStepHandler.java:148)
at org.springframework.batch.core.job.AbstractJob.handleStep(AbstractJob.java:394)
at org.springframework.batch.core.job.SimpleJob.doExecute(SimpleJob.java:135)
at org.springframework.batch.core.job.AbstractJob.execute(AbstractJob.java:308)
at org.springframework.batch.core.launch.support.SimpleJobLauncher$1.run(SimpleJobLauncher.java:141)
at org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:50)
at org.springframework.batch.core.launch.support.SimpleJobLauncher.run(SimpleJobLauncher.java:134)
at org.springframework.batch.core.step.job.JobStep.doExecute(JobStep.java:119)
at org.springframework.batch.core.step.AbstractStep.execute(AbstractStep.java:200)
at org.springframework.batch.core.job.SimpleStepHandler.handleStep(SimpleStepHandler.java:148)
at org.springframework.batch.core.job.AbstractJob.handleStep(AbstractJob.java:394)
at org.springframework.batch.core.job.SimpleJob.doExecute(SimpleJob.java:135)
at org.springframework.batch.core.job.AbstractJob.execute(AbstractJob.java:308)
at org.springframework.batch.core.launch.support.SimpleJobLauncher$1.run(SimpleJobLauncher.java:141)
at org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:50)
at org.springframework.batch.core.launch.support.SimpleJobLauncher.run(SimpleJobLauncher.java:134)
at org.springframework.batch.core.step.job.JobStep.doExecute(JobStep.java:119)
at org.springframework.batch.core.step.AbstractStep.execute(AbstractStep.java:200)
at org.springframework.batch.core.job.SimpleStepHandler.handleStep(SimpleStepHandler.java:148)
at org.springframework.batch.core.job.AbstractJob.handleStep(AbstractJob.java:394)
at org.springframework.batch.core.job.SimpleJob.doExecute(SimpleJob.java:135)
at org.springframework.batch.core.job.AbstractJob.execute(AbstractJob.java:308)
at org.springframework.batch.core.launch.support.SimpleJobLauncher$1.run(SimpleJobLauncher.java:141)
at org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:50)
at org.springframework.batch.core.launch.support.SimpleJobLauncher.run(SimpleJobLauncher.java:134)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:343)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:197)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
at org.springframework.batch.core.configuration.annotation.SimpleBatchConfiguration$PassthruAdvice.invoke(SimpleBatchConfiguration.java:127)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)
at com.sun.proxy.$Proxy71.run(Unknown Source)
at com.axisoft.alchemyj.runner.qgfkb.run(Unknown Source)
at org.springframework.boot.SpringApplication.callRunner(SpringApplication.java:797)
at org.springframework.boot.SpringApplication.callRunners(SpringApplication.java:781)
at org.springframework.boot.SpringApplication.run(SpringApplication.java:335)
at org.springframework.boot.builder.SpringApplicationBuilder.run(SpringApplicationBuilder.java:137)
at com.axisoft.alchemyj.bootstrap.AlchemyjApplication.q7igtq(Unknown Source)
at com.axisoft.alchemyj.bootstrap.AlchemyjApplication.main(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.springframework.boot.loader.MainMethodRunner.run(MainMethodRunner.java:48)
at org.springframework.boot.loader.Launcher.launch(Launcher.java:87)
at org.springframework.boot.loader.Launcher.launch(Launcher.java:50)
at org.springframework.boot.loader.JarLauncher.main(JarLauncher.java:51)
Hi Benson,
Thanks for your response.
I have sent my model to enquiry@alchemyj.io,
Regards,