Search This Blog

Thursday, June 17, 2021

Output file was found but is zero sized - Deleted [UNEXPECTED] [552457:RT37910837] java.lang.reflect.InvocationTargetException

 Error - 

Output type:   RTF

[6/16/21 6:35:58 AM] [552457:RT37904376] Output file was found but is zero sized - Deleted

[6/16/21 6:35:58 AM] [UNEXPECTED] [552457:RT37904376] java.lang.reflect.InvocationTargetException

        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

        at java.lang.reflect.Method.invoke(Method.java:597)



[6/17/21 1:23:04 PM] [552457:RT37910806] Completed post-processing actions for request 37910806.

[6/17/21 1:31:28 PM] [OPPServiceThread0] Post-processing request 37910837.

[6/17/21 1:31:28 PM] [552457:RT37910837] Executing post-processing actions for request 37910837.

[6/17/21 1:31:28 PM] [552457:RT37910837] Starting XML Publisher post-processing action.

[6/17/21 1:31:28 PM] [552457:RT37910837]

Template code: XLAACCPB02

Template app:  XLA

Language:      en

Territory:     US

Output type:   RTF

[6/17/21 1:31:28 PM] [552457:RT37910837] Output file was found but is zero sized - Deleted

[6/17/21 1:31:28 PM] [UNEXPECTED] [552457:RT37910837] java.lang.reflect.InvocationTargetException

        at sun.reflect.GeneratedMethodAccessor31.invoke(Unknown Source)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

        at java.lang.reflect.Method.invoke(Method.java:597)

        at oracle.apps.xdo.common.xml.XSLT10gR1.invokeGetDocument(XSLT10gR1.java:746)

        at oracle.apps.xdo.common.xml.XSLT10gR1.transform(XSLT10gR1.java:449)

        at oracle.apps.xdo.common.xml.XSLT10gR1.transform(XSLT10gR1.java:258)

        at oracle.apps.xdo.common.xml.XSLTWrapper.transform(XSLTWrapper.java:182)

        at oracle.apps.xdo.template.fo.util.FOUtility.generateFO(FOUtility.java:1044)

        at oracle.apps.xdo.template.FOProcessor.generate(FOProcessor.java:941)

        at oracle.apps.xdo.oa.schema.server.TemplateHelper.runProcessTemplate(TemplateHelper.java:5978)

        at oracle.apps.xdo.oa.schema.server.TemplateHelper.processTemplate(TemplateHelper.java:3470)

        at oracle.apps.xdo.oa.schema.server.TemplateHelper.processTemplate(TemplateHelper.java:3559)

        at oracle.apps.fnd.cp.opp.XMLPublisherProcessor.process(XMLPublisherProcessor.java:311)

        at oracle.apps.fnd.cp.opp.OPPRequestThread.run(OPPRequestThread.java:176)

Caused by: java.lang.NullPointerException

        at oracle.xdo.parser.v2.FilePageManager.pageLength(FilePageManager.java:242)

        at oracle.xdo.comp.CXMLStream.seek(CXMLStream.java:199)

        at oracle.xdo.comp.CXMLStream.reset(CXMLStream.java:709)

        at oracle.xdo.parser.v2.DOMParser.getDocument(DOMParser.java:143)

        ... 17 more


[6/17/21 1:31:28 PM] [552457:RT37910837] Completed post-processing actions for request 37910837.


Solution - 



Temporary Directory pointing to /usr/tmp and no space available.

Changed the directory to different where ample of space available.



Thursday, June 10, 2021

ERROR com.tableausoftware.gateway.GatewayControl - Exception while installing process

Issue - Gateway Service Does not Start and Tableau Server is Degraded


Error - 


ERROR com.tableausoftware.gateway.GatewayControl - Exception while installing process.

com.tableausoftware.tabadmin.configuration.ports.UnableToFindAvailablePortException: Port 80 was already registered for port type gateway_0:primary but isn't available. Unable to remap port

at com.tableausoftware.tabadmin.configuration.ports.PortSelector.selectPort(PortSelector.java:121)

at com.tableausoftware.tabadmin.configuration.ports.ControlAppPortsHelper.selectPorts(ControlAppPortsHelper.java:110)

at com.tableausoftware.service.control.ControlServiceApp$Commands.install(ControlServiceApp.java:341)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:498)

at com.tableausoftware.commandline.SwitchCommand$1.run(SwitchCommand.java:193)

at com.tableausoftware.commandline.SimpleCommand.execute(SimpleCommand.java:47)

at com.tableausoftware.commandline.SwitchCommand.execute(SwitchCommand.java:148)

at com.tableausoftware.service.control.ControlServiceApp.execute(ControlServiceApp.java:144)

at com.tableausoftware.service.control.ControlServiceApp.executeCommandWithApp(ControlServiceApp.java:130)

at com.tableausoftware.gateway.GatewayControl.main(GatewayControl.java:79)

2021-06-10 13:18:10.629 -0700 13432 main : INFO  com.tableausoftware.gateway.GatewayControl - Executing command with args [[install]]

2021-06-10 13:18:10.743 -0700 13432 main : INFO  com.tableausoftware.gateway.GatewayControl - Installing gateway


Solution - 

Identified the gateway port 80 is being using Sophos anti virus, changed the default port to 8000


Stopped the Tableau services 

tsm topology set-ports -n node1 -pn gateway -pv 8000

tsm pending-changes apply​​​​​​

Started the Tableau services


Reference - https://kb.tableau.com/articles/Issue/tableau-server-ports-changed-to-8000-and-higher?_gl=1*1jthnyk*_ga*MTQwMTU3ODEyNi4xNjIzMzU2NjM2*_ga_8YLN0SNXVS*MTYyMzM2OTM2OS40LjEuMTYyMzM3MTQxOS4w&_ga=2.139797235.1526428993.1623356641-1401578126.1623356636

Transportable tablespace refresh

  1.check tablespace for the user which need to refresh -------------------------------------------------------------------  SQL> select ...