Skip to main content

Data Migration

This will include topics related to data migration.

  • 615 Topics
  • 1,521 Replies
615 Topics
S
Sidekick
signilsSidekick
asked in Data Migration
Use migration job to update null values

Hi,I need my mig job to update null values against a custom field since we inserted the wrong values against it the first time around.I have put the default value as NULL against the custom field in the mig job but it isn’t updating it

1321
Jens
Hero (Employee)
J
Sidekick (Partner)
jasahuSidekick (Partner)
asked in Data Migration
App9 UPD11 - Data Archiving performance problems - doing it parallel?

The customer has lots of data in some tables - mostly quality assurance related, traceability - and keeps only last 3 months of data in the main tables.They have already setup archiving which works okay, except it started to get too slow mainly because it takes the rows in the head table one by one.As it does not put a big load on the storage we tried find some option to do it parallel, meaning several archiving jobs (orders) could run for these tables with different filters at the same time.But we found that the jobs are executed one after another:Is there a way to make them run parallel? 

320
J
Sidekick (Partner)
C
Do Gooder (Customer)
CherylLausDo Gooder (Customer)
asked in Data Migration
Data Migration SYNCDETAILS Rule

Has anyone successfully used the SYNCDETAILS Rule in a Migration Job? I made the header fields in my file the same what shows in to “Column Name” in File Mapping but when I unpack the file I get Column “xxxx” does not exist.  I am using a csv with double quotes as the Column Embrace and would expect this to apply to the headings as well. 

1172
C
Do Gooder (Customer)
B
Sidekick (Customer)
BrandowSidekick (Customer)
asked in Data Migration
Crystal Reports / Database Replacement

Hello, After moving a copy of our database to our test environment, we realized our crystal reports are grabbing data from our production environment. Where do I redirect crystal reports to look at our other server in IFS? Thanks!!!

391
Manulak
Hero (Customer)
lescobar
Do Gooder (Partner)
lescobarDo Gooder (Partner)
asked in Data Migration
Error in migration job - Org Position Structure

We’re trying to get the migration done and we have an structure like this as a CSV:CSV - source fileAfter we finish the first job which is the creation of the table with this data, there’s no error. The error comes after we execute the second job which is the one that migrates data, I get this error:ORA-20124: Error.NULLVALUE: Field [BUSINESS_UNIT_ID] is mandatory for Business Unit Relation and requires a value. Here is what’s been done:To test we only try to migrate one of the rows, the one with POS_CODE=’50000008’ The attribute string we get is: COMPANY_ID=ABCPOS_CODE=50000008POSITION_TITLE=ASSISTANT MANAGERVALID_FROM=2023-06-22-21.29.22VALID_TO=9999-12-31-00.00.00TIME_FORMAT=Minute by minuteASSIGNED_PROTECTED=FALSEEXCLUDE_FROM_EXPORT=FALSEEXCLUDE_FROM_ORG_CHART=FALSEDEFAULT_ACCESS_EXTENSION=FALSEEXPORT_EMPLOYEES=FALSESTRUCT_BU_ID=781BUSINESS_UNIT_TYPE_DB=COMPANY Here the job execution that throws the error:  and the migration job is defined like this: 

4871
NiyomalN
Hero (Partner)
AVNELBEBR
Sidekick (Partner)
AVNELBEBRSidekick (Partner)
asked in Data Migration
What are the permissions required to create Data Migration jobs?

We’ve just deployed our first IFS Cloud environment and we’re struggling with some features… One of them is regarding Data Migration Jobs. Do you guys know which exact permission (projection) a user must have in order to be able to create new Data Migration Jobs? He’s already been granted Update Allowed permission in Authorized Users screen, but I believe that will work just for the existing jobs already granted for his account, right?Hope you can help me with this.

7332
AVNELBEBR
Sidekick (Partner)
ismigulay
Do Gooder (Customer)
ismigulayDo Gooder (Customer)
asked in Data Migration
Refreshing the current form.

Hello,A repopulate can be accomplished by calling the DataSourcePopulate method on a window or a child table. Doing this on a form window will repopulate the window, and add newly created records and remove deleted records from the record selector. For table windows and child tables new records will be added and deleted records will be removed from the table.Forms can be refreshed by calling the DataSourceRefresh method. This will re-fetch only the record currently selected in the record selector, with its objid. DataSourceRefresh can be called on table windows but that will do a repopulate rather than a refresh.How do I use this in visual studio?

1200
ismigulay
Do Gooder (Customer)
B
Do Gooder (Customer)
BABPAULSDo Gooder (Customer)
asked in Data Migration
Excel Migration

I’m trying to configure an Excel Migration Job to act on an API that accepts a single attribute, which is a string of keys. I wondered if anyone has had any experience in doing this or something similar.This is the string I get from debug (without the carriage returns) that uses the POSITION_UTIL_API.Modify_Pos method…              p0_ VARCHAR2(32000) :=              'STRUCT_ID'||chr(31)||'16'||chr(30)||              'POS_CODE'||chr(31)||'500042162'||chr(30)||              'VALID_FROM'||chr(31)||'2023-05-22-00.00.00'||chr(30)||              'VALID_TO'||chr(31)||'9999-12-31-00.00.00'||chr(30)||              'OLD_POS_CODE'||chr(31)||'500042318'||chr(30)||              'SUP_POS_CODE'||chr(31)||'500042319'||chr(30);I’ve tried many variations in Excel like replacing the || with & and double-quoting like “’STRUCT_ID’”.

2642
B
Do Gooder (Customer)
R
Do Gooder (Customer)
RyanKDo Gooder (Customer)
asked in Data Migration
Data Migration - File Location

Afternoon,Has anyone created a data migration which will import a file from a specified file location on a daily basis? If so, could you share how you did it?  Scope:This migration job will pickup a file from a specified location, import the file and then archive the file upon completion. This job will run on a daily basis at 11pmI can create the data migration job to import the file using the usual manual methods however, haven’t figured out how to automate the pickup from a location.We’re currently using IFS Apps 10 however, looking to go to cloud in the near future.API to be triggered; PROJECT_TRANSACTION_API Thanks!Ryan

3602
eqbstal
Superhero (Partner)
T
Sidekick (Customer)
TimSidekick (Customer)
asked in Data Migration
Event to create Posting Proposal errors

Hello IFSers This is an Apps9 problem. I have an event & event action to create a Man Supp Invoice. I’m struggling with the Posting Proposal (PP). The debug tool doesn’t seem to reference it at all!I’ve had to guess and have created the Invoice and PP header thus:ifsapp.MAN_SUPP_INVOICE_API.NEW__(v_info,v_objid,v_objversion,attr_,'DO');ifsapp.MAN_SUPP_INVOICE_ITEM_API.NEW__(v_info,v_objid,v_objversion,attr_,'DO');ifsapp.Posting_Proposal_Head_API.New__(v_info,v_objid,v_objversion,attr_,'DO'); ..but this last step errors:ifsapp.Posting_Prop_Inv_Item_UTIL_API.New__(v_info,v_objid,v_objversion,attr_,'DO'); with : This is how I build attr_:  Client_SYS.Clear_Attr(Attr_);  --  Client_SYS.Add_To_Attr('COMPANY'                     , v_company                   , Attr_);  Client_SYS.Add_To_Attr('PARTY_TYPE'                  , 'Supplier'                  , Attr_);  Client_SYS.Add_To_Attr('IDENTITY'                    , 'AP0000'                    , Attr_);  Client_SYS.Add_To_Attr('INVOICE_ID

1531
W
Do Gooder
NiyomalN
Hero (Partner)
NiyomalNHero (Partner)
asked in Data Migration
Custom Object Data Migration issue

 I have created a migration job which is used to migrate data into some custom fields in a core table. this included some reference fields as well. I have mapped the objkey for those reference fields and everything seems ok. But when I execute the job, core method get executed and during the execution of the customer method I get the below error. any idea on this ?"ORA-20105: Message.ATTRNOTFOUND: Attribute "SQL" does not exist in message "..."”  

3604
NiyomalN
Hero (Partner)
L
Sidekick (Partner)
LakmalSidekick (Partner)
asked in Data Migration
How to define Data Archive Object for GL tables?

We need to define Data Archive Object for GL tables (MPCCOM_ACCOUNTING_TAB and GEN_LED_VOUCHER_ROW_TAB) and other related tables. Please help to find a related tables for this task.For example, I’m expecting something like this. 

2042
L
Sidekick (Partner)
P
Hero (Partner)
Priyanka Cecilia VHero (Partner)
asked in Data Migration
Cloud 22R2 - Data Migration Job Error

Hello,I’m trying to create different migration jobs for certain entities such as CustomEnumerations, SurveyAlternative and CompanySite in Cloud 22R2 and receive the error when I execute the Migration Job - ‘Error in  select  - ORA-00942: table or view does not exist’. What could be the possible reasons for this error?Please suggest. Kind RegardsPriyanka Cecilia

1742
P
Hero (Partner)
S
Sidekick
signilsSidekick
asked in Data Migration
Increasing Batch Queue processing power

Hi,In Aurena, where do I go to set/increase the batch queue processing power? i.e. number of migration jobs that can be run concurrently? Thanks

571
anbouk
Superhero
N
Do Gooder (Partner)
NishithDasDo Gooder (Partner)
asked in Data Migration
ORA-20115: DatInputContHeader. The "Input Container Header" has already been removed by other user

Hi,We are setting up Data Migration Manager in PRD environment 22R2 and our Master and Target environment is set to UAT environment. We managed to setup Target Tables and generate definition using Master environment but for one IFS view “PAYMENT_ADDRESS” we are getting issue while generating definition (after adding onto a Migration Object)“ORA-20115: DatInputContHeader. The "Input Container Header" has already been removed by other user”We tried to change the master environment to CFG and tried to generate the definition, but same issue.Has anyone encountered this type error before in Data Migration Manager Thanks,Nishith

1482
N
Do Gooder (Partner)
E
Sidekick (Customer)
ERPDMORENASidekick (Customer)
asked in Data Migration
Wich entity to import Absence Wage Time?

Dear IFS Community,We try to import Absence Wage Time but no way to find the entity/view on the debug console.On IFS application we use page "My Time Registration" or "Time Registration", "Report Time" form: Did someone already create a registration time with a migration job?

682
E
Sidekick (Customer)
I
Do Gooder (Partner)
InisrinipDo Gooder (Partner)
asked in Data Migration
EXCEL Migration Issue

Hi,I have created a simple excel migration job to create customers and address information. In here, am passing the customer id to the second method as below. When i run the job, i am always getting an error :(Without the second method, if i only run the method to create customers it works fine - which means customer gets created without an issue) Is there is anything am missing here? Environment - 22R1 Any help would be appreciated.Thanks!

4735
A
Do Gooder
B
Do Gooder (Customer)
bpamlinDo Gooder (Customer)
asked in Data Migration
table for Data source object and LU

Is there a table/query that shows the connection between the LU system control value and the data source object (to be able to tell what form/screen a custom field is coming from) 

711
kavinduxo
Hero (Partner)
S
Do Gooder (Customer)
SPRRAJDo Gooder (Customer)
asked in Data Migration
Data Migration

My Migration Job based on procedure “CREATE_TABLE_FROM_FILE” is not able to load data into the IC/TEMP table from a file holding more than 1 million records. Is there a limitation in IFS Cloud to handle the number of records during Data Migration?

1837
S
Do Gooder (Customer)
C
Do Gooder (Customer)
CarsonDo Gooder (Customer)
asked in Data Migration
Slow customer info address migration

Hello,We are seeing very slow data migration speeds when migrating Customer Info Address records. It is taking in excess of 10 seconds per address to migrate. At first, it appeared the deduplication process was the bottleneck, however even after disabling it according to this post we are still seeing slow migration speeds.Is this a known issue? We are running Apps 10 UPD 13.Thanks

940
C
Do Gooder (Customer)
S
Sidekick (Partner)
sfaureSidekick (Partner)
asked in Data Migration
Migration data : "Access denied! * not connected to Company"

I would like to migrate the field “Tax Liability” with already existents customers. I use IFSAPP account with IFS_ALL rights (and Excel ADD In). Il create a migration Job (I tried with Two jobs migration, insert or update, or Excel Add-in and i have the same result)I start the job and load the file.But when I want to start online, an error message occurs : “Access denied! User IFSAPP is not connected to Company”However, IFSAPP as a user is connected to all sites and companies. The update is allowed in the basic data migration setup. IFSAPP is a user per all the companies.Don’t know why the access is denied...    

6284
R
Do Gooder
M
Sidekick (Partner)
mtocaSidekick (Partner)
asked in Data Migration
Data Migration Manager - Connect to external database

Hi,I’m looking into the Data Migration Manager component and am looking for a way to migrate data from an external database into IFS Cloud. I took a look at the online documentation and it mentions that in the process of defining a Migration Project, there is a section where you can connect to an environment using a Database Link, which will be created by Cloud Operations in the application.Does anybody have a guide on how exactly we would create or define this Database Link?If I wanted to connect to an external database for data migration, is using the Database Migration Manager the correct process? If so, how does this process work? If not, what is the correct process?Any insights would be very much appreciated. Thanks!

3223
L
Do Gooder (Customer)
SMANUEL
Sidekick (Partner)
SMANUELSidekick (Partner)
asked in Data Migration
Migration of IFS Users

Is there a way to migrate IFS users from one environment to other (TEST to PROD) ? Thanks in AdvanceSBM

2131
L
Do Gooder (Customer)
K
Sidekick (Partner)
ksebfSidekick (Partner)
asked in Data Migration
Migrate Code Preposting Purchase order

Hello everyone, I am facing a migration problem on purchase orders.I have two simple migration jobs, and they work perfectly for the header of the order and for the lines. But I have a problem, I can't find where to update the preposting. To release a purchase order I need to fill in the C code but I didn't find it in my jobs, nor did I find another job to prepost a purchase order.Is there an easy way to update this purchase order?  Thanks anyway for your attention and future responses! Kind regards, Sébastien

1961
Jens
Hero (Employee)
D
Hero (Employee)
Devni PanduwawalaHero (Employee)
asked in Data Migration
Migration job for CONTRACT_ITEM fails with an error

When the Migration job is executed, error “ORA-20110: ContractItem.CONSALESVALUEREQD: The Sales Value must have a value since Calculation Type is Sales Value and Calculation Method is Fixed.” occurs.The purpose of this migration job is to allow us to insert data from the user defined table to contract_item_tab. A similar error has been reported here.However, the procedure name used in the current example is MIGRATE_SOURCE_DATA and not procedure INSERT_BY METHOD_NEW  IFS Aurena framework version: 22.1.10.20221205084017.0IFS Aurena client version: 22.1.10.20221205084017.0 Kindly assist in identifying the root cause of this error.

1097
D
Hero (Employee)

Badges

Show all badges
Terms & ConditionsCookie settings