1

Using MLCP copy mode trying to copy data from DEV env to UAT env.

When I tried to load it's getting error like:

23/05/18 06:58:19 WARN mapreduce.ContentWriter: Batch 124180459.0: SEC-PRIV: Need privilege: "http://marklogic.com/xdmp/privileges/xdbc-insert-in"

23/05/18 06:58:19 ERROR mapreduce.ContentWriter: Batch 124180459.0: Document failed permanently:

The option file I used:

copy 
-mode 
local 
-input_host 
UT88907.ntrs.com
-input_port  
8152 
-input_username
sys-il-wds-d
-input_password 
P@$$w0rd!
-output_host 
UT82133.ntrs.com
-output_port 
8152
-output_username 
sys-il-wds-u
-output_password 
YXf4UB3x
-collection_filter 
"WDS-raw-aip-Asset" 
-output_collections 
"WDS-raw-aip-Asset"
-fastload 
true
-batch_size 
2000000
-thread_count
16
-copy_permissions 
false
-copy_collections
true
-copy_metadata
true
-copy_quality
true
-max_split_size
500
-min_split_size
250
-copy_properties
false
Mads Hansen
  • 63,927
  • 12
  • 112
  • 147
Saiteja Vegi
  • 11
  • 2
  • Please read: [Markdown help](https://stackoverflow.com/editing-help), to format your question better. and/or: [How do I format my posts using Markdown or HTML?](https://meta.stackexchange.com/help/formatting) – Luuk May 18 '23 at 12:34
  • When you are editing the post for clarity. I suggest that you also include the execute privileges attached to "sys-il-wds-u" since the error suggests that you are missing some permissions needed for what you are trying to do. (8001->security->users->sys-il-wds-u->describe (permissions section) – David Ennis -CleverLlamas.com May 18 '23 at 13:03

1 Answers1

1

The message is telling you that the user that you are using does not have the necessary privileges to perform the work.

On the target server (the one you are trying to copy data into), ensure that the user account has a role assigned that has the xdbc:insert-in Execute Privilege

Mads Hansen
  • 63,927
  • 12
  • 112
  • 147