9 Replies Latest reply: Jul 23, 2014 7:36 PM by RMarques RSS

    Unable to import Data Load Mapping

    RMarques

      Hi guys!

       

      Is there any known issue while importing Data Load mappings?

      Because I got no error, but the mappings are not there.

      BTW, 11.1.2.3.500

       

      Thanks

       

      Rafael Marques

        • 1. Re: Unable to import Data Load Mapping
          KKT

          I am assuming that you are loading your mappings through Flat file or excel.

           

          While loading please make sure your map do not have any special character or spaces at the end or beginning.

           

          Please check and let us know.

           

          Thanks,

          ~KKT~

          • 2. Re: Unable to import Data Load Mapping
            RMarques

            Tried both.

            Even if I put just 1 single line w/o special character.

            Importing from 11.1.2.2 to 11.1.2.3.500

            The difference is just the last field that is for Data Rule name and as I am no using nothing specific, I am leaving just a comma at the and. But also tried w/o the comma.

            To solve this while I dont have much time, I've created a INSERT instruction do do this (increasing the Sequence for the TDATAMAP table)

            • 3. Re: Unable to import Data Load Mapping
              user10757003

              Are you sure you are using the correct format:

              <Source>,<Target>,<Datarule>,Description if using the "current Dimension" load. I assume from your details that you are loading explicit records.

               

              If you are still having issues, manually enter one mapping record then export to test file and verify your text file matches. 

              • 4. Re: Unable to import Data Load Mapping
                2709276

                I will suggest you to create one line manually in Data Load Rule workspace page and then export the file in your local drive. Then update mapping table in format file and import it back to FDMEE.

                The format of mapping table are change in FDMEE 11.1.2.3 in comparison with older fusion editions.

                 

                Hope this will help..

                • 5. Re: Unable to import Data Load Mapping
                  RMarques

                  Hi

                   

                  I tried to export,but its not working.

                  I have "An error occured while exporting the file" error message when I put the filename end hit enter.

                   

                  @44acff74-1673-45e3-836b-6e408caf65fe

                  • 6. Re: Unable to import Data Load Mapping
                    RMarques

                    I get the below when I try do Export:

                     

                    [2014-07-10T13:00:09.978+10:00] [ErpIntegrator0] [NOTIFICATION] [ERPI-105011] [oracle.apps.erpi.model] [tid: 47] [userId: <anonymous>] [ecid: 004zSh9YczCAxGT5mBG7yZ0002iL0003ue,0:1:4] [APP: AIF#11.1.2.0] [URI: /workspace/logon] [SRC_CLASS: com.hyperion.aif.odi.common.util.OdiConstants] [SRC_METHOD: logDebugInfo] EPMERPI- BATCH_SIZE: null

                    [2014-07-10T13:00:09.978+10:00] [ErpIntegrator0] [ERROR] [] [oracle.apps.erpi.ui] [tid: 47] [userId: <anonymous>] [ecid: 004zSh9YczCAxGT5mBG7yZ0002iL0003ue,0:1:4] [APP: AIF#11.1.2.0] [URI: /workspace/logon] [SRC_CLASS: com.hyperion.aif.gl.common.setup.userinterface.backing.FileBrowser] [SRC_METHOD: exportArtifact] null[[

                    java.lang.NumberFormatException: null

                            at java.lang.Integer.parseInt(Integer.java:417)

                            at java.lang.Integer.parseInt(Integer.java:499)

                            at com.hyperion.aif.file.common.util.FileBasedLoad.<init>(FileBasedLoad.java:140)

                            at com.hyperion.aif.file.map.ExportMap.<init>(ExportMap.java:123)

                            at com.hyperion.aif.gl.common.setup.userinterface.backing.FileBrowser.exportMappings(FileBrowser.java:217)

                            at com.hyperion.aif.gl.common.setup.userinterface.backing.FileBrowser.exportArtifact(FileBrowser.java:198)

                            at com.hyperion.aif.gl.common.setup.userinterface.backing.FileBrowser.exportXML(FileBrowser.java:163)

                            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)

                            at com.sun.el.parser.AstValue.invoke(AstValue.java:187)

                            at com.sun.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:297)

                            at org.apache.myfaces.trinidadinternal.taglib.util.MethodExpressionMethodBinding.invoke(MethodExpressionMethodBinding.java:53)

                            at org.apache.myfaces.trinidad.component.UIXComponentBase.broadcastToMethodBinding(UIXComponentBase.java:1433)

                            at org.apache.myfaces.trinidad.component.UIXCommand.broadcast(UIXCommand.java:183)

                            at oracle.adf.view.rich.component.fragment.UIXRegion.broadcast(UIXRegion.java:181)

                            at oracle.adf.view.rich.component.fragment.UIXRegion.broadcast(UIXRegion.java:181)

                            at oracle.adf.view.rich.component.fragment.UIXRegion.broadcast(UIXRegion.java:181)

                            at oracle.adfinternal.view.faces.lifecycle.LifecycleImpl.broadcastEvents(LifecycleImpl.java:1100)

                            at oracle.adfinternal.view.faces.lifecycle.LifecycleImpl._executePhase(LifecycleImpl.java:446)

                            at oracle.adfinternal.view.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:219)

                            at javax.faces.webapp.FacesServlet.service(FacesServlet.java:265)

                            at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)

                            at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)

                            at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:301)

                            at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:27)

                            at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:57)

                            at oracle.adf.model.servlet.ADFBindingFilter.doFilter(ADFBindingFilter.java:211)

                            at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:57)

                            at oracle.adfinternal.view.faces.webapp.rich.RegistrationFilter.doFilter(RegistrationFilter.java:131)

                            at org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl$FilterListChain.doFilter(TrinidadFilterImpl.java:447)

                            at oracle.adfinternal.view.faces.activedata.AdsFilter.doFilter(AdsFilter.java:60)

                            at org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl$FilterListChain.doFilter(TrinidadFilterImpl.java:447)

                            at org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl._doFilterImpl(TrinidadFilterImpl.java:271)

                            at org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl.doFilter(TrinidadFilterImpl.java:177)

                            at org.apache.myfaces.trinidad.webapp.TrinidadFilter.doFilter(TrinidadFilter.java:92)

                            at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:57)

                            at oracle.adfinternal.view.faces.webapp.rich.RegistrationFilter.doFilter(RegistrationFilter.java:131)

                            at org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl$FilterListChain.doFilter(TrinidadFilterImpl.java:447)

                            at oracle.adfinternal.view.faces.activedata.AdsFilter.doFilter(AdsFilter.java:60)

                            at org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl$FilterListChain.doFilter(TrinidadFilterImpl.java:447)

                            at org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl._doFilterImpl(TrinidadFilterImpl.java:271)

                            at org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl.doFilter(TrinidadFilterImpl.java:177)

                            at org.apache.myfaces.trinidad.webapp.TrinidadFilter.doFilter(TrinidadFilter.java:92)

                            at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:57)

                            at oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:119)

                            at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:324)

                            at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:460)

                            at oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:103)

                            at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:171)

                            at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:71)

                            at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:57)

                            at oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:119)

                            at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:324)

                            at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:460)

                            at oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:103)

                            at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:171)

                            at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:71)

                            at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:57)

                            at oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:163)

                            at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:57)

                            at weblogic.servlet.internal.RequestEventsFilter.doFilter(RequestEventsFilter.java:27)

                            at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:57)

                            at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3730)

                            at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3696)

                            at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)

                            at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2273)

                            at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2179)

                            at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1490)

                            at weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)

                            at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)

                    • 7. Re: Unable to import Data Load Mapping
                      Francisco Amores

                      Hi,

                       

                      you have a number exception. That is probably raised due to having system setting "Batch Size" not defined.

                      Can you check in System Settings > Profile Type = File > Batch Size

                      If it's blank set it to number. Default is 1000.

                       

                      004zSh9YczCAxGT5mBG7yZ0002iL0003ue,0:1:4] [APP: AIF#11.1.2.0] [URI: /workspace/logon] [SRC_CLASS: com.hyperion.aif.odi.common.util.OdiConstants] [SRC_METHOD: logDebugInfo] EPMERPI- BATCH_SIZE: null

                      [2014-07-10T13:00:09.978+10:00] [ErpIntegrator0] [ERROR] [] [oracle.apps.erpi.ui] [tid: 47] [userId: <anonymous>] [ecid: 004zSh9YczCAxGT5mBG7yZ0002iL0003ue,0:1:4] [APP: AIF#11.1.2.0] [URI: /workspace/logon] [SRC_CLASS: com.hyperion.aif.gl.common.setup.userinterface.backing.FileBrowser] [SRC_METHOD: exportArtifact] null[[

                      java.lang.NumberFormatException: null

                      • 8. Re: Unable to import Data Load Mapping
                        RMarques

                        Yes!

                        My fault. Forgot to put this in DEV

                        Will test import again

                         

                        Thanks

                        • 9. Re: Unable to import Data Load Mapping
                          RMarques

                          Now its working.

                          How I couldn't see that.

                          Weird, because in the other env this field is not missing.

                           

                          Thanks once again