Hi there
I made test and looks like
the procedure: hou.hipFile.merge
not working in Python Script node
in python Script node:

import hou
import os

network = hou.node("/stage/").

asset_file_name = "path to file"
hou.hipFile.merge(asset_file_name, node_pattern="*", overwrite_on_conflict=True, ignore_load_warnings=False)

Python error: Traceback (most recent call last):
File "<stdin>", line 6, in <module>
File "C:\PROGRA~1/SIDEEF~1/HOUDIN~1.640/houdini/python3.9libs\houpythonportion\ui.py", line 1119, in decorator
return func(*args, **kwargs)
File "C:\PROGRA~1/SIDEEF~1/HOUDIN~1.640/houdini/python3.9libs\hou.py", line 52202, in merge
return _hou.hipFile_merge(self, *args, **kwargs)
hou.OperationFailed: The attempted operation failed.
Node cook is in progress: /stage/pythonscript1

What I am doing wrong?